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)
  • SQL Server DML Triggers - Tips & Tricks - Part 1 ("Intro" & "Triggers activation order")

    This is the first blog post in a series of posts about Tips & Tricks of SQL Server DML Triggers. Introduction Triggers are often one of the main reason of quarrel between Developers and DBAs, between those who customize a database application and those who provides it. They are often the first database objects to be blamed when the ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on December 29, 2014
  • 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