XPost: microsoft.public.sqlserver.programming   
   From: genew@ocis.net   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)