Writing Stored Procedures for Microsoft SQL Server

Chapter 15. Writing Triggers

IN THIS CHAPTER

• How triggers are defined

• How triggers are processed

• Creating triggers

• Nested triggers

• Problems with triggers

You might find it strange that there is a chapter on triggers in a book about stored procedures. When you think about it, though, it's really not that strange. In the most basic of explanations, a trigger is a specialized type of stored procedure that's conditionally executed based on certain actions in your database. For example, you can create a trigger that will execute when a row is inserted into a table. Until the release of SQL Server 2000, the only types of triggers available were those that ran in the context of a transaction that added, modified, or deleted data from a table. Microsoft's ...