sqlserver将查询中一行内容转化为多行内容

 

 

WITH CTE AS
(
SELECT top 5 TaskID ,Attachments from [V_AllAccessoriesAompression]
)
SELECT a.TaskID,c.Attachments
FROM (SELECT TaskID,CONVERT(XML,'<R><V>' + REPLACE(Attachments,';','</V><V>') + '</V></R>') AS Col FROM CTE) a
CROSS APPLY(SELECT t.c.value('.','nvarchar(100)')
FROM a.Col.nodes('R/V') AS t(c)) AS c(Attachments)

使用 如上语句将查询中数据转化

带转化内容

 

 

 

转化后内容