Triggers

  • Ryan Barrett

    Right there with Babe

    Points: 731

    Comments posted to this topic are about the item Triggers

  • Koen Verbeeck

    SSC Guru

    Points: 258985

    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: 8273

    Good question

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

  • call.copse

    SSCoach

    Points: 17261

    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

    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 🙁

  • This was removed by the editor as SPAM

  • Iulian -207023

    SSCertifiable

    Points: 7509

    nice one, thank you

    Iulian

  • Thomas Abraham

    SSChampion

    Points: 10761

    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: 2842

    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: 184381

    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

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

  • Cliff Jones

    SSChampion

    Points: 10517

    mbova407 (11/2/2011)


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

    That's the spirit!

  • SQLRNNR

    SSC Guru

    Points: 281252

    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 Wymore

    SSCoach

    Points: 16668

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

  • Revenant

    SSC-Forever

    Points: 42467

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

    Thanks!

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

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