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

 

兼容中英文逗号：，,

　　　　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