Viewing 2 posts - 1 through 2 (of 2 total)
For
Declare @a float=29123455612589.23610
SELECT CONVERT(varchar(max), convert(decimal(25,5) , @a))
Result :29123455612589.23400 which is rounded again.
March 30, 2015 at 6:25 am
#1787309
for this value @a float=1234556.235 result is 1.234556235E6
I am not expecting exponent value.
March 30, 2015 at 4:04 am
#1787253