求一句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 =