Changing datatype from int to decimal

hi

how to Change datatype from int to decimal with precission 8 and scale 3.in ms sql

Quote:

Originally Posted by war

hi

how to Change datatype from int to decimal with precission 8 and scale 3.in ms sql

Moved to MS SQL forum.
And please do not double post.|||In Enterprise Manager right click on table name and choose 'Design Table'

Good Luck.|||Alter table <tableName>
Alter Column <ColumnName> Decimal(8,3)
Go