Home Forums SQL Server 2019 SQL Server 2019 - Development BEFORE TRIGGER Idea Posted to Microsoft Connect RE: BEFORE TRIGGER Idea Posted to Microsoft Connect

  • May 22, 2017 at 1:37 am

    #1943504

    Jeff Moden - Sunday, May 21, 2017 11:20 AM

    Hugo Kornelis - Sunday, May 21, 2017 3:03 AM

    Jeff Moden - Saturday, May 20, 2017 2:33 PM

    I just posted a plea and a link to this post on "the thread".  I'd love to see "BEFORE Triggers" become a reality instead of those gosh-awful "Instead Of" triggers.  I have little love in general for Oracle but this one of those things that Oracle absolutely did right from the git.  It would make writing audit triggers a whole lot easier to prevent unnecessary duplication in audit tables, which become some of the biggest tables of them all.

    Another upvote. I like the idea in the item, allthough I'd like just implementing BEFORE triggers even better.
    However, I do not share your dislike for INSTEAD OF triggers. They are a great tool for some specific purposes. I have used them to expose views as if they were the base tables, hiding the actual base tables, and allowing full updatability even when SQL Server itself would consider the view non-updatable or misunderstand how to change the base tables to correspond to the actual change,

    You misunderstand my dislike for "Instead Of" triggers.  As you say, they ARE great for specific purposes.  A perfect example is when the target of an insert is actually an updateable view built for one reason or another.  Still, you have to control everything there instead of just what you need to control, whatever that may be.[/quote]
    Considered the new Pirates of the Caribbean is released in 2 days, guess how I read the  '...ARE....' in this reply ( #Palmface ) 😉

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me