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

发布时间 2023-04-13 13:35:19作者: 诗情寻知己

 

兼容中英文逗号:,,

    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