ÇóSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

SQL ÖУ¬ÓÐÒ»ÁУ¨L1£©ÊÇMoney

ֵΪ£º12345.67

ÏëÒªµÃµ½£º12,346

ÇóSQLÓï¾ä

---

ûÓдó´ó»Ø´ð ˵Ã÷sqlÐв»Í¨
»¹ÊDz»ÒªÓÃsql×ö

---

»¹ÊÇÓóÌÐòÀ´´¦Àí°É

---

¿ÉÒÔд µ«ÊÇû±ØÒªÓÃSQLÀ´Ð´ ÍòһҪдҲÊÇ¿ÉÒ﵀ ÉÏ´ÎÓÐÈË·¢¹ýÕâ¸öº¯Êý

---

ÀûÓÃconert()¿ÉÒÔת»»,ÄãÕÒÕÒ,ÎÒÍü¼ÇÁË.

---

SQL code:
select convert(varchar,convert(money,round(12345.67, 0)),1)

---

ÒýÓÃ

SQL code
select convert(varchar,convert(money,round(12345.67, 0)),1)

ÇÉ°¡ ²»¹ý¶àÁËÁ½¸ö0

---

SQL code:


create function fn_testnum(@m money)
returns varchar(20)
as
begin
declare @s varchar(20),@r varchar(20)
set @s=reverse(ltrim(ceiling(cast(@m as dec(28,4)))))
while len(@s)>0
select @r=isnull(@r+',','')+left(@s,3),
@s=stuff(@s,1,3,'')
return reverse(@r)
end
go

declare @m money
set @m=12345.67
select dbo.fn_testnum(@m)
/*
--------------------
12,346

(1 ÐÐÊÜÓ°Ïì)
*/
set @m=1234566545.67
select dbo.fn_testnum(@m)
/*
--------------------
1,234,566,546

(1 ÐÐÊÜÓ°Ïì)
*/

---

SQL code:
create