Christian Buettner-167247 (5/4/2010)
Does not look like it is settings related.Here is the code executed via each client tool:
Hey Christian,
Thanks for the awesome feedback there - but have you noticed that SQLCMD gets the answer wrong?
ROUND(0.5, 0) is "1.0" not ".0"! I got the same results in my tests (see the rather pretty screenshot).
This has to be a bug. If no-one comes up with a comprehensive answer, this is going on Connect.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi