Mega Code Archive

 

Categories / MSSQL / Data Type

 

SELECT CONVERT(VarChar(50), @Num, 2)

4> 5> 6> 7> DECLARE @Num Float 8> SET @Num = 1234.56 9> SELECT CONVERT(VarChar(50), @Num, 2) 10> GO -------------------------------------------------- 1.234560000000000e+003 (1 rows affected) 1>