Category Archives: Keywords

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

    3

    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

    6

    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

    2

    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

    3

    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

    4

    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

Follow

Get every new post delivered to your Inbox.

Join 487 other followers