在 SQL Server 中有什么方法可以将列数据拆分为多行？

使用DelimitedSplit8K （https://www.sqlservercentral.com/articles/tally-oh-an-improved-sql-8k-“csv-splitter”-function）

;
 with cte as 
( 
select id, prodlines, ItemNumber, Item = ltrim(Item), 
grp = dense_rank() over (partition by id order by replace(replace(ltrim(Item), '(Read)', ''), '(Write)', '')) 
from #prodLines pl 
cross apply dbo.DelimitedSplit8K(prodlines, ',') c 
) 
select id, prodlines, prod = stuff(prod, 1, 1, '') 
from cte c 
cross apply 
( 
select ',' + Item 
from cte x 
where x.id = c.id 
and x.grp = c.grp 
order by x.Item 
for xml path('') 
) i (prod)