SQL合并列值和拆分列值
表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, '<root><v>' + REPLACE(stringS, ',', '</v><v>') + '</v></root>')FRO