SQL Rounding Problems in 2005 and 2000

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 开发者_JS百科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?

---

Exactly the same target server, database, datatype, processor, architecture etc?

If not, it's simply how the tools will display an approximate float value

---

Most things round off numbers for display.

~$ ghci
Prelude> 2.7
2.7
~$ irb
>> 2.7
=> 2.7
~$ python
>>> 2.7
2.7000000000000002

For interactive use, this is usually good enough — the only person to see the query analyzer is you, so why does it matter? For actual display, you should specify a format anyway. If you really need the exact value of "2.7", then you should be using a decimal type anyway, as countless articles and answers can tell you.