Saturday, January 19, 2013

Difference between AFTER and INSTEAD OF TRIGGERS

1. Views cannot have AFTER triggers.
2. We can have multiple AFTER triggers on EACH of the Update/Insert/Delete statements, where as we can have only ONE INSTEAD OF triggers for all these.
3. AFTER triggers do not affect the DML operation that caused them, however INSTEAD OF triggers are invoked instead of the DML operation.