Sumit Kesarwani Total Post:782 Points:3910 Posted by Sumit Kesarwani June-15-2013 4:17 AM MSSQL Server MSSQL Server 1 Answer(s) 1715 View(s) Ratings: Rate this:
Sumit Kesarwani Post:782 Points:3910 What are the different modes of firing triggers? Posted on 4 years ago After Trigger: An AFTER trigger fires after SQL Server completes all actions successfully. Instead of Triggers: An INSTEAD OF trigger causes SQL Server to execute the code in the trigger instead of the operation that caused the trigger to fire.
Post:782
Points:3910What are the different modes of firing triggers?
After Trigger: An AFTER trigger fires after SQL Server completes all actions successfully.
Instead of Triggers: An INSTEAD OF trigger causes SQL Server to execute the code in the trigger instead of the operation that caused the trigger to fire.