SQL Rounding Problems in 2005 and 2000
Posted
by azamsharp
on Stack Overflow
See other posts from Stack Overflow
or by azamsharp
Published on 2010-04-12T19:25:20Z
Indexed on
2010/04/12
19:33 UTC
Read the original article
Hit count: 495
I have a value in the database which is 2.700000002. When I run a query in Management studio in SQL SERVER 2005 I get 2.7. But when I run in SQL SERVER 2000 query analyzer it comes 2.700000002.
2.70000002 is correct why is SQL SERVER 2005 trying to change the value by rounding it or selecting the floor value?
© Stack Overflow or respective owner