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

Related posts about sql-server-2005

Related posts about sql-server-2000