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))

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,...