SQL Server Triggers Question:
Describe triggers features and limitations?
Answer:
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
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
| Previous Question | Next Question |
| Explain triggers? | Explain Syntax for viewing, dropping and disabling triggers? |