Full precision output of floating point types in SQL Server Management Studio?

No SQL Server Management Studio rounds floating point values for display purposes; there is a Connect suggestion to change this behavior but it is closed "as By Design However SQLCMD osql and the Query Analyzer do not SQLCMD -E -S server -Q"SELECT CONVERT(FLOAT, 1555.4899999999998).

No. SQL Server Management Studio rounds floating point values for display purposes; there is a Connect suggestion to change this behavior, but it is closed "as By Design". However, SQLCMD, osql and the Query Analyzer do not.

SQLCMD -E -S server -Q"SELECT CONVERT(FLOAT, 1555.4899999999998).

Floats are stored as fractions, which causes them to often be slightly innacurate when doing operations on them. This is okay when you have a graphics application where the innaccuracy is much less significant than the size of a pixel, but it's a huge issue in something like an accounting application where you're dealing with money. I would venture to say that the accuracy of a decimal is more important to most applications than any benefit in speed or size they would get from using a float.

The database schema is outside of my control, unfortunately. I am 100% in agreement that float is a bad choice for this application, but if it were the right type I'd still expect a more accurate representation in Management Studio. – Simon Nov 14 at 15:25.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.