Adding Columns to a Table with a Query in MS SQL
In MS SQL Server, the following procedure should be followed to add a column to a table with a query.
ALTER TABLE {Table Name} ADD {Column Name} {Data Type} {NULL or NOT NULL}Example uses are given below..
ALTER TABLE Tbl_Customers ADD Address NVARCHAR(500) NULL ALTER TABLE Tbl_Products ADD ProdCode int NOT NULL