SQL合并列值和拆分列值
'<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, stringS VARCHAR(30));--插入数据INSERT INTO tb VALUES ( 1, 'aa,bb' );I