THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » t-sql » SQL Techniques   (RSS)
  • disallow results from triggers

    A setting that I noticed a while back when looking at sys.configurations was disallow results from triggers.  Triggers are one of my favorite subjects, and you will find a lot of good uses of them in my book (triggers are also well named, as poor usage of them will allow you to shoot your foot off in a heartbeat as I discussed in my earlier ...
    Posted to Louis Davidson (Weblog) by drsql on June 6, 2009
  • The joys of a calendar table (ytd, month, and quarter summations)

    There was a question on the forums the other day that asked how to get a total for the current month, the current quarter, and year to date.  It is actually a pretty easy task when using a calendar table.  I have one you can use here (I fixed an error in it that I just found too!): ...
    Posted to Louis Davidson (Weblog) by drsql on December 9, 2006
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement