Difference between using "FOR" vs. "AFTER" clause in Trigger

[forevertechie]

Hi,

Can someone explain the difference between using the "FOR" clause versus the "AFTER" clause while defining a trigger for a table?

For instance:

CREATE TRIGGER sometrig ON sometable
FOR DELETE ....

vs.

CREATE TRIGGER sometrig ON sometable
AFTER DELETE ....


Thanks,
- forevertechie

 

[JohnDTampaBay]

From BOL, Designing Triggers:

Specifying AFTER is the same as specifying FOR, which is the only option available in earlier versions of SQL Server.

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)