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