Changing datatype from int to decimal - Post.Byes

X

war

New Member

Join Date: Oct 2007

Posts: 5
#1

Changing datatype from int to decimal

Oct 11 '07, 09:56 AM

hi

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

MVP

Join Date: Sep 2006

Posts: 13225
#2

Oct 12 '07, 10:03 AM

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.
Comment
iburyak

Recognized Expert Top Contributor

Join Date: Nov 2006

Posts: 1016
#3

Oct 12 '07, 12:44 PM

In Enterprise Manager right click on table name and choose 'Design Table'

Good Luck.
Comment
shaileshb

New Member

Join Date: Jun 2007

Posts: 27
#4

Oct 17 '07, 12:00 PM

Alter table <tableName>
Alter Column <ColumnName> Decimal(8,3)
Go
Comment

Previous template Next

Working...