Home Forums SQL Server 2014 Development - SQL Server 2014 Script to create Triggers RE: Script to create Triggers

  • January 30, 2016 at 2:10 pm

    #1855525

    Orlando Colamatteo (1/30/2016)

    TheSQLGuru (1/30/2016)

    Such a shame too. But it wasn't fully baked when it was released and it has never gotten the attention it needed/deserved from the product team.

    I could not agree more. The only place I use MERGE is in place of the proprietary UPDATE...JOIN or DELETE...JOIN statements to add protection from error 8672.

    I use UPDATE ... JOIN or DELETE ... JOIN and make very sure that I check what I'm getting back and that I have 1..1 matches to the tables being deleted/updated/

    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