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...
-
I was trying my hands at creating a .NET 2.0 component that can be consumed by a COM application. One of the errors I got in the process of...
-
After editing the post-build event of my project in VS 2005, the following error came up "'Exec' task needs a command to execut...