Modify a column without truncating the table
515449May 29 2006 — edited May 30 2006HI! All
I need to modify a column Discount Decimal(7,2) to decimal(7,4) ,the column has a data i dont want to truncate the table .when i try to run this script
Alter table <Table Name > modify column Discount(7,4)
iam getting a error stating ,"Empty the column before altering"
can any one help me