SQL Server 2008: Trigger Question

Giganews Newsgroups
Subject: SQL Server 2008: Trigger Question
Posted by:  Gene Wirchenko (gen…@ocis.net)
Date: Tue, 01 Mar 2011

Dear SQLers:

          CREATE TRIGGER ... {FOR | AFTER | INSTEAD OF} ...
Do FOR and AFTER mean the same thing here?  In particular, I am
wondering whether a FOR trigger executes before or after the
underlying data is modified.  My text says before on one page and
after on the next, and MSDN is not clear either.

Sincerely,

Gene Wirchenko

Replies