LinkedIn

Wednesday, 29 October 2008

Add columns to t-sql table


ALTER TABLE ModelDataByID


ADD

A_DebtFeesRate decimal(11, 2) NULL,
A_CcaFeesRa decimalte (11, 2) NULL,
A_ExchangeDate decimal NULL,
A_ConditionalDate decimal NULL,
A_CompletionDate decimal NULL

OR

ALTER TABLE [User] ALTER COLUMN Internal_External varchar (20);

that's it.
RuSs