SQL Server Triggers Interview Question:

Describe triggers features and limitations?

Submitted by: Administrator

Trigger features:-

1. Can execute a batch of SQL code for an insert, update or delete command is executed
2. Business rules can be enforced on modification of data

Trigger Limitations:-
1. Does not accept arguments or parameters
2. Cannot perform commit or rollback
3. Can cause table errors if poorly written
Submitted by: Administrator