I have a T-SQL query :
select CAST(0 as float(53)),CONVERT(nvarchar(max),CAST(0 as float(53)),128)
the output of which is
Can some one explain why it is not 0,0 ? The database is SQL Server 2008.
Syntax for CONVERT:
[style] for float data type :
You can use below command to get expected result :