Inside Microsoft® SQL Server™ 2005

Chapter 8. Triggers

In this chapter:

AFTER Triggers

INSTEAD OF Triggers

DDL Triggers

CLR Triggers

Conclusion

Triggers are routines that fire automatically as a result of an event in the database server. Microsoft SQL Server supports data-manipulation language (DML) and data-definition language (DDL) triggers, which can be developed either with T-SQL or with .NET code and can fire AFTER or INSTEAD OF the triggering event. In this chapter, I’ll describe in detail the different types of triggers, first describing DML AFTER triggers and later, in a dedicated section, DDL AFTER triggers. I’ll also focus on AFTER triggers that you write with T-SQL, and in a dedicated section, I’ll describe triggers that you develop with .NET code (CLR triggers).

Triggers are ...