SQL²éѯÎÊÌ⣿ - MS-SQL Server / »ù´¡Àà

Óиö×Ö¶ÎAÈçÏ£º
2,3,5
44,2,445
23,22,3
Ò²¾ÍÊÇÓɶººÅ·Ö¸ôµÄÕûÊý¡£
ÎÊÌ⣺Ôõô²éѯÁ½¸ö¶ººÅÖмäµÄÊý£¿

---

select 
substring('2,3,5',charindex(',','2,3,5')+1,charindex(',','2,3,5',charindex(',','2,3,5')+1)-charindex(',','2,3,5')-1)

---

SQL code:
select parsename(replace(a,',','.'),3)+','+parsename(replace(a,',','.'),1)
from
(select '2,3,5' a
union all select '44,2,445'
union all select '23,22,3'
) b
/*

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2,5
44,445
23,3

(3 ÐÐÊÜÓ°Ïì)


*/

---

ÒýÓÃ

SQL code
select parsename(replace(a,',','.'),3)+','+parsename(replace(a,',','.'),1)
from
(select '2,3,5' a
union all select '44,2,445'
union all select '23,22,3'
) b
/*

---------------------¡­¡­

Ó¦¸ÃÖ»Òªparsename(replace(a,',','.'),2)

---

ÒýÓÃ

ÒýÓà 2 Â¥ beirut µÄ»Ø¸´:
SQL code
select parsename(replace(a,',','.'),3)+','+parsename(replace(a,',','.'),1)
from
(select '2,3,5' a
union all select '44,2,445'
union all select '23,22,3'