Question

Based on action, what are the trigger types in SQL Server and when are they executed?

Answer

There are three types of triggers:

• DML triggers - executed when data in a table is modified (for INSERT, UPDATE or DELETE statement)
• DDL triggers - executed when certain DDL statements are executed (both database and server level)
• Logon triggers - executed when user logs on

DML triggers can be defined as INSTEAD OF, AFTER or BEFORE. DDL and logon triggers can be defined as FOR or AFTER.

Read More..   [32134 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  ·