查询结果显示的问题,在线等待给分;)

将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)

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus