摘要: 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] fr 阅读全文
posted @ 2011-12-09 16:49 小师傅 阅读(462) 评论(0) 推荐(0) 编辑