Category Archives: Keywords

  1. Adding a column to a table with a default (NULL vs NOT NULL)


    October 30, 2013 by Kenneth Fisher

    There are lots of ways to learn new things, or be reminded of old things. One of my favorites is …
    Continue reading

  2. Use TOP instead of SET ROWCOUNT


    October 7, 2013 by Kenneth Fisher

    Both TOP and SET ROWCOUNT are both valid methods of limiting the result sets from a query. They are however …
    Continue reading

  3. GO


    May 6, 2013 by Kenneth Fisher

    Did you know that the GO command isn’t really part of T-SQL? It’s what’s called a batch separator. And in …
    Continue reading

  4. IsMSShipped


    January 23, 2013 by Kenneth Fisher

    I just wanted to do a brief highlight of a handy little object property. For those of you who aren’t …
    Continue reading

  5. keyword DEFAULT


    August 20, 2012 by Kenneth Fisher

    In 12 years of working with SQL it was only last year that I came across the keyword DEFAULT and …
    Continue reading


Get every new post delivered to your Inbox.

Join 831 other followers