1.生成測試數(shù)據(jù)：
create table team(name varchar(32),person varchar(32));
insert into team values('A','Tom');
insert into team values('A','Jim');
insert into team values('A','Anny');
insert into team values('B','Ivy');
insert into team values('B','Henry');
insert into team values('C','Dar');
insert into team values('C','Rk');
insert into team values('D','Cenic');
select * from team;
2.創(chuàng)建合并團隊成員姓名自定義函數(shù)：
create function fun_combName(@teamname varchar(32))
returns varchar(4000)
as
begin
declare @temp varchar(4000)
set @temp = ''
select @temp = @temp+';'+person from team where name = @teamname
set @temp = stuff(@temp,1,1,'')
return @temp
end
3.執(zhí)行查詢語句：
select name,person = dbo.fun_combName(name) from team group by name order by name;
注：測試完可以刪除測試數(shù)據(jù)：
drop function fun_combName;
drop table team;