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