sql float转换成字符,数据不变
------解决方案--------------------
先转为decimal
------解决方案--------------------
- SQL code
declare @a floatset @a=123456789.987654321select CAST(@a AS NVARCHAR(50)),CAST(CAST(@a AS decimal(38,10)) AS varchar(50))/* -------------------------------------------------- --------------------------------------------------1.23457e+008 123456789.9876543100(1 行受影响)*/
------解决方案--------------------
如果float过大,溢出decimal,那怎么处理呢?
是不是最开始就保存成 varchar?