Based on action, what are the trigger types in SQL Server and when are they executed?
There are three types of triggers:
DML triggers can be defined as INSTEAD OF, AFTER or BEFORE.
DDL and logon triggers can be defined as FOR or AFTER.
SQL Server Interview Questions · · · ·