Difference between FOR and AFTER triggers?

sql sql-server-2005 triggers
sqlchild picture sqlchild · Mar 17, 2011 · Viewed 77.2k times · Source

What's the difference between FOR and AFTER triggers?

Answer

Ben picture Ben · Mar 17, 2011

There is no difference, they do the same thing. 

CREATE TRIGGER trgTable on dbo.Table FOR INSERT,UPDATE,DELETE

Is the same as

CREATE TRIGGER trgTable on dbo.Table AFTER INSERT,UPDATE,DELETE

An INSTEAD OF trigger is different, and fires before and instead of the insert and can be used on views, in order to insert the appropriate values into the underlying tables.

Related questions

IF UPDATE() in SQL server trigger

If there's: IF UPDATE (col1) ...in the SQL server trigger on a table, does it return true only if col1 has been changed or been updated? I have a regular update query like UPDATE table-name SET col1 = 'x', col2 = 'y' …

Read More
Asynchronous Triggers in SQL Server 2005/2008

I have triggers that manipulate and insert a lot of data into a Change tracking table for audit purposes on every insert, update and delete. This trigger does its job very well, by using it we are able to log …

Read More
Can I have two different insert triggers on the same table?

They seem to be allowed as I can see both my insert triggers listed under the table with different names. Is it common or a bad practice? I am using SQL Server 2005

Read More