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

WHAT ARE THE DIFFERENT MODES OF FIRING TRIGGERS?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
 1715  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.

      Modified On Mar-27-2018 04:07:14 AM

Answer

NEWSLETTER

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

© Copyright © 2010 - 2018 MindStick Software Pvt. Ltd. All Rights Reserved