将一行以 逗号分割的数据拆分为多行不带逗号的数据

将一行以 逗号分割的数据拆分为多行不带逗号的数据

 

 

SELECT B.value bedArray
FROM(
SELECT bedArray = CONVERT(xml,'<root><v>' + REPLACE(bedArray, ',', '</v><v>') + '</v></root>') FROM [dbo].[test] A
)A
OUTER APPLY(
SELECT value = N.v.value('.', 'varchar(100)') FROM A.bedArray.nodes('/root/v') N(v)
)B

转载于:https://www.cnblogs.com/Anthony518/p/11220471.html