Interviews - C# Corner

Rohit Kumar
How many types of Triggers in SQL SERVER?
By Rohit Kumar in SQL Server on Dec 02, 2012
  • sd farook
    Sep, 2013 19

    There are three type of Triggers 1)DML a)Instead of Trigger:Instead of trigger are fired in place of the triggering action such as an insert,update, or delete b)After Trigger:After trigger excute following the triggering action ,such as an insert,update,or delete. 2)DDL Trigger: This type of trigger is fired against DDL statements like Drop Table,Create Table,Or Alter Table,DDL Triggers are always after Triggres 3)Logon trigger: This type of trigger is fired against a LOGON event before a user session is established to the SQL Server

    • 1
  • Hemlata
    May, 2016 3

    There are three type of Triggers ......................... 1. DML triggers a).INSERT, UPDATE, & DELETE statements, when data is modified in tables/views. b).INSTEAD OF INSERT ,INSTEAD OF UPDATE ,INSTEAD OF DELETE 2. DDL triggers operate on CREATE, ALTER, DROP 3.LOGON triggers Please refer following for more details... https://msdn.microsoft.com/en-IN/library/ms189799.aspx https://technet.microsoft.com/en-us/library/ms179288(v=sql.105).aspx https://technet.microsoft.com/en-us/library/ms179288(v=sql.105).aspx

    • 0
  • sd farook
    Sep, 2013 19

    There are three type of Triggers 1)DML a)Instead of Trigger:Instead of trigger are fired in place of the triggering action such as an insert,update, or delete b)After Trigger:After trigger excute following the triggering action ,such as an insert,update,or delete. 2)DDL Trigger: This type of trigger is fired against DDL statements like Drop Table,Create Table,Or Alter Table,DDL Triggers are always after Triggres Logon trigger: This type of trigger is fired against a LOGON event before a user session is established to the SQL Server

    • 0
  • Praneet Rane
    Mar, 2013 19

    There are 2 main types of triggers: 1.After triggers (also known as For triggers. 2.Instead of triggers 1.After triggers further classified into : a.After Insert b.After Update c.After Delete. 2. Instead of triggers further classified into : a.Instead of Insert. b. Instead of Update. c. Instead of Delete.

    • 0
  • Sriram Ramasamy
    Jan, 2013 7

    There are 2 types of triggers. They are 1. DML Triggers ---> a. After trigger b. Instead of trigger 2. DDL Triggers

    • 0
  • Sriram Ramasamy
    Jan, 2013 7

    There are 2 types of triggers. They are 1. DML Triggers ---> a. After trigger b. Instead of trigger 2. DDL Triggers

    • 0
  • Sonu Singh
    Dec, 2012 28

    There are three action query types that you use in SQL which are INSERT, UPDATE and DELETE. So, there are three types of triggers... AFTER INSERT Trigger. AFTER UPDATE Trigger. AFTER DELETE Trigger. triggers are classified into two main types:- 1 After Triggers (For Triggers) 2 Instead Of Triggers

    • 0

Download Free eBooks

Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS