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 |
kevindrys
Starting Member
7 Posts |
Posted - 2013-02-01 : 12:48:45
|
There has to be something obvious that I'm overlooking here. I have data in a SQL Server 7.0 table that has data type numeric(18,3). I have an equivalent table in SQL Server 2008 R2, but it has data type decimal(9,3). The data in the 7.0 table is -0.031, but the data in the 2008 table is 0.000. Other examples 1.577 is rounded up to 2.000, .777 is rounded up to 1.000.I thought the numeric and decimal types were functionally the same. It seems that decimal is the more commonly used. I *thought* I read where numeric may be going away in some future version of SQL Server.I can use the numeric data type and solve this problem, but I was wondering if I could find an explanation as to yes, decimal rounds off. |
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2013-02-01 : 12:51:31
|
Did you move the data from SQL 7 to 2008R2? If so how? |
|
|
kevindrys
Starting Member
7 Posts |
Posted - 2013-02-01 : 12:56:13
|
I'm using Import Wizard to pull the data over. |
|
|
|
|
|