WHAT ARE THE DIFFERENT MODES OF FIRING TRIGGERS?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
 1614  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    What 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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!