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 |
|
SQLError
Yak Posting Veteran
63 Posts |
 Posted - 2004-08-01 : 14:11:17
|
| Hi, I have made my own datatype and I want to replace every decimal datatype in my tables with the new datatype. I do not want to dothis manually.Is there a way to do this using sql?thanks |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-01 : 14:45:11
|
| ????? Are all your decimal datatypes in the system currently the same? I just want to make sure you have considered that. If you have, you can find all the decimal datatypes in syscolumns and run ALTER TABLE statements to replace them.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
SQLError
Yak Posting Veteran
63 Posts |
Posted - 2004-08-01 : 15:41:56
|
| Yes, they are the same precision and scale.I will try that. thank you |
|
|
|
|
|
|
Bulk operation: changing one data type to another