ALTER TABLE Table_name ADD column_name data_type, column_name data_type example : ALTER TABLE MyTable ADD ID INT, Name nvarchar(50)ALTER TABLE table_name ADD column1 column1_definition, ADD column2 column2_definition, ADD column3 column3_definition, ... ADD column columnn_definition;UPDATE Person.Person Set FirstName = 'Kenneth' ,LastName = 'Smith' WHERE BusinessEntityID = 1ALTER TABLE tblcommodityOHLC alter column CC_CommodityContractID NUMERIC(18,0); ALTER TABLE tblcommodityOHLC alter column CM_CommodityID NUMERIC(18,0);