top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

How many types of triggers are there?

+1 vote
43 views

Hai,friends anybody explain the types of triggers in Sql Server

posted Nov 18, 2014 by Vinitha

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes

Database Triggers: Database Triggers are Procedures that are automatically executed as a result of insert in, update to, or delete from table.

Database triggers have the values old and new to denote the old value in the table before it is deleted and the new indicated the new value that will be used. Database Triggers are useful for implementing complex business rules, which cannot be enforced using the integrity rules. We can have the trigger as before trigger or After Trigger and at Statement or Row level.
E.g.: operations insert, update, and delete 3
Before, after 3*2 A total of 6 combinations
At statement level (once for the trigger) or row level (for every execution) 6 * 2 A
total of 12.

Thus a total of 12 combinations are there and the restriction of usage of 12 triggers has been lifted from Oracle 7.3 Onwards.

answer Nov 18, 2014 by Arun Gowda
0 votes

There are three types of triggers.
1.DML Triggers
--> AFTER Triggers
--> INSTEAD OF Triggers
2.DDL Triggers
3.CLR Triggers

answer Nov 18, 2014 by Manikandan J
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...