|
kevindrys
Starting Member
7 Posts |
 Posted - 02/01/2013 : 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. |
|
Data type decimal is rounding off
