Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vack
Aged Yak Warrior
530 Posts |
 Posted - 2011-12-07 : 10:15:57
|
| SQL 2000I have an existing table with a field that has a datatype of Decimal. Lenght=9 Precision=9 and Scale=2.I would like to change this to Precision=12 and Scale=4. I tried Design table and changed the Precision and Scale and that seemed to save ok. But the Length is still showing as 9. When I try to insert a 4 decimal number it still only pulls in 2 decimals. Is it possible to do this with existing data in the table? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-07 : 10:21:52
|
| its possible using alter table ..........alter column .... statement------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Change Precision and Scale on field