简单的 行转列
电脑版发表于:2018/12/20 12:48
行转列
DECLARE @Str VARCHAR(100)
SELECT @Str = '1,2,3,4,5'
SELECT b.Line FROM
(
SELECT Line = CONVERT(XML,'<root><v>'+REPLACE(@Str,',','</v><v>')+'</v></root>')
)a
OUTER APPLY
(SELECT Line = REPLACE(C.v.value('.','nvarchar(100)'),' ','') FROM a.Line.nodes('/root/v')C(v))b
效果图