I am using SQL Server 2005 Express edition.
I need to store and retrieve values in a scientific notation in the database. For that purpose I have taken the column datatype as Float. But to my surprise when I insert values which have scientific notation in the table, it rounds off the value and stores
and thus while retrieving the values I get the rounded value and not the scientific notation value.
e.g. When in an Insert statement, I give a value -5.31E+02, it stores the value in the database as -531.
Even a simple select statement like "SELECT -5.31E+02" gives the result as -531.
Am I missing anything here ?
Can anybody please tell me how do I store and retrieve value in the same notation I give while inserting the data ?
View Complete Post