更新时间:2022-11-26 19:40:03
试试这个:
SELECT
STUFF((SELECT
',' + fd.v.value('(.)[1]', 'varchar(10)')
FROM
Temp12345
CROSS APPLY
col1.nodes('/fd/field/v') AS fd(v)
FOR XML PATH('')
), 1, 1, '')
这给了我 A,B,C
- 它也适合你吗?
This gives me A,B,C
- does it work for you, too?