Displaying posts published in

November 2012

Handy SQL Server Snippets

There are a few SQL Server tasks I do infrequently and always forget the syntax. I’m going to start collecting them here. ALTER TABLE ExistingTable ADD NewColumn INT NOT NULL DEFAULT(0) WITH VALUES This adds a new column with a default value of 0, and populates existing rows with 0 in the new column. ALTER […]