将MONEY类型的字段显示问题,如 将1000000.88显示成1,000,000.88,应该怎么做啊?谢谢大家
---------------------------------------------------------------
declare @n money
set @n = 8425652.15
select convert(varchar(100),@n,1)
--8,425,652.15
---------------------------------------------------------------
select convert(varchar(100),$1000000.88,1)
---------------------------------------------------------------
select convert(varchar(50),表达式,1)