Answers

Question and Answer:

  Home  MS SQL Server Triggers

⟩ Describe triggers features and limitations?

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

 158 views

More Questions for you: