sql2005 xml use tempdb go if(object_id('tb') is not null) drop table tb create table tb(f1 varchar(800),f2 int,f3 int) goinsert into tb values('AA',5,5) insert into tb values('BB',6,3) insert into tb values('CC',5,2) insert into tb values('DD',7,1)go select cast (replace((select f1 from tb for xml path ('' )), '</f1><f1>',',') as xml).value ('.' , 'varchar(max)'),sum(f2),sum(f3) from tb /* (无列名) (无列名) (无列名) AA,BB,CC,DD 23 11 */
use tempdb
go
if(object_id('tb') is not null)
drop table tb
create table tb(f1 varchar(800),f2 int,f3 int)
goinsert into tb values('AA',5,5)
insert into tb values('BB',6,3)
insert into tb values('CC',5,2)
insert into tb values('DD',7,1)go
select cast (replace((select f1 from tb for xml path ('' )),
'</f1><f1>',',') as xml).value ('.' , 'varchar(max)'),sum(f2),sum(f3)
from tb
/*
(无列名) (无列名) (无列名)
AA,BB,CC,DD 23 11
*/