Category Archives: Keywords
-
Adding a column to a table with a default (NULL vs NOT NULL)
4October 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 -
Use TOP instead of SET ROWCOUNT
13October 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 -
GO
6May 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 -
IsMSShipped
3January 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 -
keyword DEFAULT
5August 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