SQL合并列值和拆分列值
ACE(( SELECT string FROM tb N WHERE id = A.id FOR XML AUTO ), '<N string="', ','), '"/>', ''), 1, 1, '')) N;方法2SELECT id, stringS = STUFF(( SELECT ',' + string FROM tb t WHERE id = tb.id FOR XML PATH('')), 1, 1, '')FROM tb GROUP BY id;删除表DROP TABLE tb;拆分列值合并列值的逆过程--创建表CREATE TABLE tb ( id INT, stri