May 10, 2010 at 12:44 am
difference between after trigger & instead of trigger?
May 10, 2010 at 12:49 am
After trigger is executed after the DML operation (insert, update or delete) was executed on the table. Instead of trigger runs Instead of the DML operation that was submitted to the server. You can read about it more in BOL (Books On Line).
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 10, 2010 at 1:24 am
dhaval_dsa (5/10/2010)
difference between after trigger & instead of trigger?
google it , you will get good and satisfactory link/details about it
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply