Wednesday 23 January 2013

Add column With Default Value, SQL Server



ALTER TABLE Table Name
ADD [Column Name] [Data Type] NOT NULL
CONSTRAINT [Constraint Name] DEFAULT default Value