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.
Liked By
Write Answer
What are the different modes of firing triggers?
Join MindStick Community
You have need login or register for voting of answers or question.
Sumit Kesarwani
15-Jun-2013After 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.