SQL合并列值和拆分列值
d FROM tb ) AOUTER APPLY ( SELECT stringS = STUFF(REPLACE(REPLACE(( 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;删除