What are the different modes of firing triggers?
Ask by Sumit Kesarwani
Updated 23 Sep 2020
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.