Home > DeveloperSection > Interviews > What are the different modes of firing triggers?

Posted on    June-15-2013 4:17 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  1574  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Posted on    June-15-2013 12:00 AM

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.

Don't want to miss updates? Please click the below button!

Follow MindStick