Showing posts with label precission. Show all posts
Showing posts with label precission. Show all posts

Sunday, February 12, 2012

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