Triggers

Question

Triggers

Ryan Barrett

Right there with Babe

Points: 731
More actions
November 1, 2011 at 8:35 pm

#259431

Comments posted to this topic are about the item Triggers
November 2, 2011 at 4:31 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 23 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Nice question. It was tempting to select FOR, AFTER, INSTEAD OF :-D.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ryan007 SSCrazy Eights Points: 8275 More actions · Answer 2

Good question

Ryan
//All our dreams can come true, if we have the courage to pursue them//

call.copse SSCoach Points: 18056 More actions · Answer 3

Darn, I jumped wrong there, I guess it is because I just didn't think about it. Not really gone for the concept of DDL triggers much yet so just selected INSTEAD OF, FOR and AFTER.

CoolCodeShare SSCrazy Points: 2584 More actions · Answer 4

call.copse (11/2/2011)
Darn, I jumped wrong there, I guess it is because I just didn't think about it. Not really gone for the concept of DDL triggers much yet so just selected INSTEAD OF, FOR and AFTER.

Me tooo 🙁

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 5

Iulian -207023

SSCertifiable

Points: 7639

November 2, 2011 at 6:01 am

#1402088

nice one, thank you

Iulian

Thomas Abraham SSChampion Points: 10761 More actions · Answer 6

Koen Verbeeck (11/2/2011)
Nice question. It was tempting to select FOR, AFTER, INSTEAD OF :-D.

Right there with you. Then I realized the third member (with AFTER and INSTEAD OF) of the group was CLR, and they are technically just types of DML triggers.

Also almost went for INSERT, UPDATE, DELETE, until I realized these were just event types.

Of course, it helped that I was already on my second mug of green tea. 🙂

(Later)

I should have mentioned the half dozen "fun" size Butterfinger candy bars I ate from a huge bag left on the break room table by a thoughtful (read evil) co-worker. After the first one, it's just a feeding frenzy! :hehe:

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

DBA_Dom SSCrazy Points: 2902 More actions · Answer 7

You got to love those questions that are simplistic enough to make you think twice about the answer. Nice Question.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 8

I got this one wrong but that's because I considered a Logon trigger part of the DDL trigger family because it was added to SQL Server at the same time as DDL triggers. Not a bad question though.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Mike Is Here Hall of Fame Points: 3348 More actions · Answer 9

Mike Is Here

Hall of Fame

Points: 3348

November 2, 2011 at 7:21 am

#1402124

Yeah... one point... now two with this post.

Cliff Jones SSChampion Points: 10547 More actions · Answer 10

mbova407 (11/2/2011)
Yeah... one point... now two with this post.

That's the spirit!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

Nice question. I liked it. It made me take a quick second thought - but types practically gave it away.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Ken SSCoach Points: 17191 More actions · Answer 12

Doh! Didn't think through it enough. Oh well. Good question.

Revenant SSC-Forever Points: 42467 More actions · Answer 13

Yes, a good one to highlight importance of a second thought.

Thanks!