ÇóÒ»¾äsql - MS-SQL Server / ÒÉÄÑÎÊÌâ

1,2
4,5,6
ÉÏÃæÁ½¸ö×Ö·û´®ÖмäÓöººÅ¸ô¿ª£¬ÇóÒ»¾äsql²åÈëµ½ÏÂÃæµÄ±íÖÐ

AID BID
1 4
1 5
1 6
2 4
2 5
2 6

---

1,2
4,5,6
ÊÇ·ÅÔÚÄÄÀïµÄ°¡...

---

ÒýÓÃ

1,2
4,5,6
ÊÇ·ÅÔÚÄÄÀïµÄ°¡...

ÊÇÁ½¸ö²ÎÊý

---

SQL code:
declare @s1 varchar(1000),@s2 varchar(1000),@str varchar(1000)

select @s1 = '1,2',@s2 = '4,5,6'

select @str = 'select * from (select '+replace(@s1,',',' c1 union select ') + ' c1) a cross join (select '+ replace(@s2,',',' c2 union select ') + ' c2) b '

exec(@str)

/* ½á¹û
c1 c2
----------- -----------
1 4
1 5
1 6
2 4
2 5
2 6

*/

---

SQL code:

DECLARE @a varchar(100)
DECLARE @b varchar(100)
SET @a = '1,2'
SET @b = '4,5,6'

SELECT a = a.v, b = b.v
from (
SELECT v = x.n.value('.','int')
from (
SELECT ValuesXML = CAST('<root>' +
REPLACE((SELECT v = @a FOR XML PATH('')),',','</v><v>') +
'</root>' AS XML)
) t
CROSS APPLY t.ValuesXML.nodes('/root/v') x(n)
) a
CROSS JOIN (
SELECT v =