Describe triggers features and limitations?
Submitted by: AdministratorTrigger 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
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
Read Online SQL Server Triggers Job Interview Questions And Answers
Top SQL Server Triggers Questions
☺ | Explain trigger classes i.e. instead of and after trigger? |
☺ | Explain Syntax for viewing, dropping and disabling triggers? |
☺ | What are the instances when triggers are appropriate? |
☺ | Explain triggers? |
☺ | How to invoke a trigger on demand? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |