--创建转换函数
create function f_FormatNumber
(
@n numeric(18,6)
)
returns varchar(30)
as
begin
declare @t varchar(30)
set @t=cast(@n as varchar(30))
while right(@t,1)='0'
set @t=left(@t,len(@t)-1)
declare @i int
set @i=charindex('.',@t)
if @i=0
set @i=len(@t)
else
set @i=@i-1
while @i>3
begin
set @t=left(@t,@i-3)+','+right(@t,len(@t)-@i+3)
set @i=@i-3
end
if right(@t,1)='.'
set @t=left(@t,len(@t)-1)
return @t
end
go
--调用
select dbo.f_FormatNumber(123456789.123)