SELECT convert(numeric(38,0),cast('4.102e+011' AS float))
Sunday, April 24, 2016
Converting exponential number to numeric T-SQL
Following query can be used to convert an exponential number to numeric format.
SELECT convert(numeric(38,0),cast('4.102e+011' AS float))
SELECT convert(numeric(38,0),cast('4.102e+011' AS float))
Subscribe to:
Posts (Atom)
What is success?
The journey of life takes us through varied experiences like landing an admission at a prestigious college, earning a degree, getting hired,...
-
Recently after a domain password change, I got the following error in trying to run the webrole. Can not log on locally to WebRole as us...
-
In trying to setup a site on a Windows 2008 server, I ran into the following error message Handler "PageHandlerFactory-Integrated"...
-
For some reason, Hive metastore.exe (which runs as a service) did not create the metastore db that is required for Hive to store table defi...