Handling Scientific Notation in SQL Server table
Posted on 2007-11-26
I am loading data into SQL Server using DTS. That seems to be working fine. Many of the values are in scientific notation, ie. 1.00E-005, -6.63E-011, etc. I set the decimal datatype with precision 28 and scale 14 to handle storing the values correctly and that works. However, I just found out that they prefer to keep the scientific notation in the field value, so they want 1.00E-005, not the expanded decimal version. Some people may read the tables directly to work with the data and they don't want these users to have to convert the data back to scientific notation. Does anyone know how to handle this or is loading as a decimal as I have done the only way to do it?