SQL Server:如何将浮点格式化为字符串,而不使用逗号?

Format 此格式的函数

declare @num as float
set @num=21739130.43478260

select format(@num, N'#.##############################');
-- output : 21739130.4347826

有很多方法可以做到这一点:

转换函数:

SELECT CONVERT(varchar(100), Cast(@num as decimal(38, 2)))
--output : 21739130.43

SELECT CONVERT (VARCHAR(50), @num,128)
--output : 21739130.4347826090000000

SELECT LTRIM(STR(@num, 25, 99))
--output : 2.1739130434782609e+007

str

 STR(1000000000E0/46E0,len(STR(1000000000E0/46E0))+10,16)

 output=21739130.43478260900

替换功能可满足您的要求

select  replace(format(1000000000E0/46E0,N'N99'), ',', '')

输出

21739130.434782600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000