Labels

Sunday, 27 December 2015

SQL Server - Differences between Instead of Triggers and After Triggers


The below are the basic differences between Instead of Triggers and After Tirggers.

1.Instead of Triggers will fire before the triggering action (DML) and before constraints are processed where as after triggers will fire after the triggering action -DML and after any constraints are processed.

2. Each table or view can have one Instead of Trigger for each triggering action (DML) where as
After triggers can have several triggers for each triggering action .

No comments:

Post a Comment