Posted by Erland Sommarskog on 07/08/05 00:18

Ford Desperado (ford_desperado@yahoo.com) writes:
> I've been reading the docs and playing around, but I'm still not
> getting the difference.

That is because there isn't any!

If memory servers, FOR was the original syntax. I suspect that AFTER
has been added to align with ANSI standards. FOR is not very precise,
where as AFTER tells us that the trigger fires after the statement.
That in difference to BEFORE and INSTEAD OF triggers. (Of which SQL
Server has the latter, but not the former.)


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Combining Stored Procedures
• Prev in forum: Re: stored procs - specifying ORDER BY as a parameter
• Thread view: Re: difference between FOR INSERT and AFTER INSERT triggers

[Reply to this message]