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 |
|
azamsharp
Posting Yak Master
201 Posts |
 Posted - 2010-04-12 : 15:15:54
|
| Hi, 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?Mohammad Azam www.azamsharp.net |
|
|
rebooot
Starting Member
9 Posts |
Posted - 2010-04-12 : 16:43:51
|
| What's the data type that you are using? |
 |
|
|
|
|
|
Rounding Problems in SQL SERVER 2005 and SQL 2000