摘要: create table tb(id int, value varchar(10)) insert into tb values(1, 'aa')insert into tb values(1, 'bb')insert into tb values(2, 'aaa')insert into tb values(2, 'bbb')insert into tb values(2, 'ccc')go select id, [values]=stuff((select ','+[value] from tb 阅读全文
posted @ 2013-12-04 14:04 李小加 阅读(229) 评论(0) 推荐(0) 编辑