如何将浮点值转换为nvarchar [英] how to convert float value into nvarchar
本文介绍了如何将浮点值转换为nvarchar的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何将浮点值转换为nvarchar
解决方案
您需要将Float转换为十进制,然后转换为nvarchar。
例如
DECLARE @FltVal AS Float
SELECT @ FltVal = 12345 。 67
SELECT CAST(CAST( @ FltVal AS 十进制( 8 , 2 )) AS NVarChar ( 20 ))
阅读: http://stackoverflow.com/questions/4881674/cast-or-convert-a-float-to-nvarchar [ ^ ]
使用角色(小于柱> as nvarchar ( 50 ))
how to convert float value into nvarchar
解决方案
You need to convert Float to decimal and then to nvarchar.
e.g.
DECLARE @FltVal AS Float SELECT @FltVal = 12345.67 SELECT CAST(CAST(@FltVal AS Decimal(8, 2)) AS NVarChar(20))
Read this : http://stackoverflow.com/questions/4881674/cast-or-convert-a-float-to-nvarchar[^]
UseCast(<column> as nvarchar(50))
这篇关于如何将浮点值转换为nvarchar的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文