Re: difference between FOR INSERT and AFTER INSERT triggers
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 7 Jul 2005 21:18:55 +0000 (UTC)
Ford Desperado (ford_desperado@xxxxxxxxx) 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@xxxxxxxxxxxxx
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
.
- Follow-Ups:
- Re: difference between FOR INSERT and AFTER INSERT triggers
- From: Ford Desperado
- Re: difference between FOR INSERT and AFTER INSERT triggers
- References:
- difference between FOR INSERT and AFTER INSERT triggers
- From: Ford Desperado
- difference between FOR INSERT and AFTER INSERT triggers
- Prev by Date: Re: Use of user defined in SELECT clause
- Next by Date: Re: Combining Stored Procedures
- Previous by thread: difference between FOR INSERT and AFTER INSERT triggers
- Next by thread: Re: difference between FOR INSERT and AFTER INSERT triggers
- Index(es):
Relevant Pages
|
