Sql Server 表列内容逗号隔开转行显示

 

兼容中英文逗号：，,

?

1 2 3 4 5 6 7 8 9 10 11 12 13

SELECT a.id,    　　　　b.Content     FROM     (         SELECT id,                Content = CAST('<v>' + replace(Content, ',', '</v><v>') + '</v>' AS XML)         FROM tb_Content     ) a     OUTER APPLY     (         SELECT Content = t.c.value('.', 'varchar(50)')         FROM a.Content.nodes('/v') AS t(c)     ) b