Monthly Archives: July 2012

SQL Server – Add Column Script

–Add a column to an existing table ALTER TABLE dbo.EmployeeADD Active varchar(1)GO –Add default to new column ALTER TABLE dbo.EmployeeADD CONSTRAINT Employee_Active┬áDEFAULT (‘N’) FOR ActiveGO

Tagged with: , , , ,
Posted in Visual Studio Code Examples