Update existing column datatype in MS SQL Server database without losing data

Alter existing column datatype using Alter command eg:-

Suppose in existing table "Products" column MRP datatype is decimal(18,4) and now you want to increase its limit to decimal(18,6). Use below query

ALTER TABLE Auction_Products alter column MRP decimal(18,6)

Related Alrticles

FREE!!! Registration