Intermediate T-SQL - Programming Triggers
Triggers automatically execute when events like inserting, deleting, or modifying rows in a table occur, as well as when other events like creating databases, tables, or users logging on occur. You will learn about the different types of triggers, including AFTER triggers, which execute after an SQL operation, and INSTEAD OF triggers, which perform in place of an SQL operation.