Exploring SQL Server Triggers: Part 2

摘要

This month I will expand on last months column―the foundation of SQL Server~(TM) triggers and the features that they expose (http://msdn.microsoft.com/msdnmag/issues/03/12/DataPoints). I have targeted this column in response to many of the questions I have received regarding triggers. I'll begin with INSTEAD OF triggers and the differences between them and AFTER triggers. I'll then discuss some situations in which to use INSTEAD OF triggers including allowing updates to multiple tables through views. Finally, I'll discuss how to handle transactions in triggers, writing triggers to handle changes to multiple rows in a table, and determining which columns were modified within triggers.