declare @i decimal(15,3) set @i=123456.789 select convert(varchar,cast(@i as money),1) /* ------------------------------ 123,456.79 */
还是要转换成 Money 有没有其它的方法
为什么不能转换成Money?
create function f_FormatMoney(@amt float) returns varchar(20) as begin return convert(varchar,cast(@amt as money),1) end goselect dbo.f_FormatMoney(123456.789)drop function dbo.f_FormatMoney /* 123,456.79 */
set @i=123456.789
select convert(varchar,cast(@i as money),1)
/*
------------------------------
123,456.79
*/
为什么不能转换成Money?
returns varchar(20)
as
begin
return convert(varchar,cast(@amt as money),1)
end
goselect dbo.f_FormatMoney(123456.789)drop function dbo.f_FormatMoney
/*
123,456.79
*/