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.
Total Post:782
Points:3910After 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.