http://snipplr.com/language/sql/tags/default Recent snippets posted on Snipplr.com en-us Mon, 20 May 2013 14:28:48 GMT http://snipplr.com/view/64667/sql--sql-server--add-column-with-default-value-and-check-constraint/ Example of SQL syntax to add a new column to an existing table, define a default value to the columns for the existing rows and also add a check constraint to limit the values that the column can hold.

]]> Fri, 20 Apr 2012 01:45:29 GMT http://snipplr.com/view/64667/sql--sql-server--add-column-with-default-value-and-check-constraint/