THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Triggers   (RSS)
  • Speaking this weekend at SQL Saturday 277 - Richmond

      One of my favorite locations to speak or attend is when Richmond has a SQL Saturday. (though if you are an organizer of another SQL Saturday's I have submitted to, note that I said ''one of my favorites'' :)). This will be the third time I go to Richmond. I like it for several reasons:   The people - I have coworkers coming up ...
    Posted to Louis Davidson (Weblog) by drsql on March 19, 2014
  • Bad habits to kick : abusing triggers

    In my last post in this series, I talked about choosing inappropriate data types.  This time, I want to touch on a few ways that I see triggers being misused.  Using a trigger at all A lot of people think that they need a trigger.  They allow direct access to tables instead of forcing data access through stored procedures, and ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 12, 2009
  • It's 2008, and @@ROWCOUNT ain't what it used to be. Don't use it in triggers.

    During SQL Server 2008 beta testing, Aaron Bertrand noted that the value of @@rowcount inside a trigger could be unexpected, if the triggering statement was MERGE. The consequences of this can be pretty bad, but fortunately there's a simple workaround. You need to do something if anyone might invoke MERGE against tables with triggers that ...
    Posted to Steve Kass (Weblog) by skass on April 29, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement