Trigger

• vinoth-750003

  SSC-Addicted

  Points: 437

  More actions

  December 8, 2010 at 2:12 am

  #97539

  What are types Trigger in SQL SERVER 2008?

  A) Triggers are classified into three main types:-

  1.DML Trigger

  2.DDL Trigger

  3.Logon Trigger

  B) Triggers are classified into two main types: -

  1.After Triggers (For Triggers)

  2. Instead Of Triggers

  Which one is correct A or B

• VSSGeorge

  SSCrazy Eights

  Points: 8151

  More actions

  December 8, 2010 at 3:41 am

  #1259986

  Hi

  Just search in Books online or MSDN

  That will help you.

  The types of DML triggers are

  1)AFTER Triggers

  2)INSTEAD OF Triggers

  3)CLR Triggers

  Links:

  http://msdn.microsoft.com/en-us/library/ms189799.aspx

  http://msdn.microsoft.com/en-us/library/ms178134.aspx

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  December 8, 2010 at 4:14 am

  #1259995

  Please don't cross post. It just wastes people's time and fragments replies

  No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1031703-391-1.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass