SQL Server 根据某特殊字符拆分或合并

SQL Server 根据某特殊字符拆分

//value是你的字段名
B表中代码不用更改

SELECT A.id, B.value FROM(
SELECT id, [value] = CONVERT(xml,’’ + REPLACE([value], ‘,’, ‘’) + ‘’) FROM tb )A
OUTER APPLY( SELECT value = N.v.value(’.’, ‘varchar(100)’) FROM A.[value].nodes(’/root/v’) N(v)
)B

SQL Server 根据某特殊字符合并

select did, name = (stuff((select ‘,’ + name from #表 where did =
a.did for xml path(’’)),1,1,’’)) from #表 a group by did