Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

DML Triggers Expand / Collapse
Author
Message
Posted Tuesday, December 11, 2007 10:34 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, November 17, 2008 9:27 PM
Points: 81, Visits: 128
Comments posted to this topic are about the item DML Triggers

Thanks,
Prashant
Post #432139
Posted Wednesday, December 12, 2007 4:11 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 25, 2009 5:38 AM
Points: 315, Visits: 49
There are 3 types of DML triggers: CLR Triggers, AFTER Triggers,INSTEAD OF Triggers. Answer given is wrong in the post.

-------------------------------------------
Cheers,
Sur...
'The bend in the road is not the end of the road Unless u refuse to take the turn"
Post #432231
Posted Wednesday, December 12, 2007 6:32 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:11 PM
Points: 15,517, Visits: 27,898
That's just what I was going to point out. I even went & checked it in BOL.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #432272
Posted Wednesday, December 12, 2007 6:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 10, 2008 4:40 AM
Points: 132, Visits: 52
Hey Me too..
This site
http://msdn2.microsoft.com/en-us/library/ms178134.aspx

says that A CLR Trigger can be either an AFTER or INSTEAD OF trigger. A CLR trigger can also be a DDL trigger.

So... please correct the answer...



Regards,
Genie Cool

Post #432277
Posted Wednesday, December 12, 2007 7:24 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 2, 2013 2:50 PM
Points: 1,234, Visits: 201
Even though a CLR trigger can actually be an After or Instead Of trigger, it is still a unique type and makes the answer to the question 3 instead of 2.
Post #432297
Posted Wednesday, December 12, 2007 7:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, February 18, 2011 8:01 AM
Points: 221, Visits: 153
Three! Says so right here. Answer choices are incorrect. However, I suppose you could quibble about the CLR trigger thing.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2e3f74a7-05b6-445a-8156-4aa10232c324.htm

Post #432299
Posted Wednesday, December 12, 2007 8:06 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, November 17, 2008 9:27 PM
Points: 81, Visits: 128
Hi guys,
I think question and answer both are correct. because if you people see the question read it carefully,
"How many types of DML triggers in SQL are present? (DML - Data Modification Language)"

The question says that How many types of DML Triggers ok, its not asking how many type of triggers, its asking about DML Triggers,
So the answer is AFTER and INSTEAD of trigger.
But tell you the intresting thing that i have also ticked the 2nd option that is
3 types (DML triggers, DDL triggers and Logon triggers)
But if u'll read the question carefully then the question and answer both are correct.

Thanks...:)


Thanks,
Prashant
Post #432326
Posted Wednesday, December 12, 2007 8:49 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 7:34 AM
Points: 417, Visits: 1,146
In this BOL page, http://msdn2.microsoft.com/en-us/library/ms178134.aspx titled Types of DML Triggers, it states After, Instead Of, and CLR Triggers are types of DML triggers. For triggers are used prior to SQL Server 2005. The only option in the answer that includes all of these is answer number 4.
Post #432361
Posted Wednesday, December 12, 2007 9:02 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, November 13, 2008 9:13 AM
Points: 499, Visits: 76
It's definitely 3. BOL (normally) doesn't lie.
Post #432369
Posted Wednesday, December 12, 2007 9:05 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, November 17, 2008 9:27 PM
Points: 81, Visits: 128
rlondon (12/12/2007)
In this BOL page, http://msdn2.microsoft.com/en-us/library/ms178134.aspx titled Types of DML Triggers, it states After, Instead Of, and CLR Triggers are types of DML triggers. For triggers are used prior to SQL Server 2005. The only option in the answer that includes all of these is answer number 4.


HI,
Actually in the page CLR also listed as DML triggers but if you see CLR triggers can be used as DML as welll as DDL triggers, and also
"CLR triggers are dependent to .NET " that is why there is only the pure DML triggers that are AFTER and INSTEAD, CLR comes under both CML and DDL,
this is what i think.... What you think.,..


Thanks,
Prashant
Post #432372
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse