Translate to Tamil

Amazon Best Offer

AliExpress Offers

Online Income

Wikipedia

Search results

Wednesday, 5 January 2011

What are the Different Types of Triggers?


There are two types of Triggers.

1)  DML Trigger

There are two types of DML Triggers

  • Instead  of Trigger
                Instead of Triggers are fired in place of the triggering action such as an insert, update, or delete.

  • After Trigger
              After triggers execute following the triggering action, such as an insert, update, or delete.

2)   DDL Trigger
This type of trigger is fired against Drop Table, Create Table, Alter Table or Login events. DDL Triggers are always After Triggers.

 Share This Post


Services

gads

Online Earning

© 2014