Triggers are one of the most powerful tools for ensuring the quality of the data in your database. The range of commands that can be executed from within them and their ability to automatically fire give them a distinct role in defining a sound database solution.

The next chapter, "User-Defined Functions," covers a new set of subroutines that allow users to expand upon the built-in functions that are defined as part of the Transact-SQL language.

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features