SQL合并列值和拆分列值
)), 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' );INSERT INTO tb VALUES ( 2, 'aaa,bbb,ccc' );--查询原始数据SELECT * FROM dbo.tb;--查询拆分数据SELECT A.id, B.stringFROM ( SELECT id, stringS = CONVERT(XML,