create table #t(fld varchar(100))insert into #t(fld) values('A')
insert into #t(fld) values('B')
insert into #t(fld) values('C')
insert into #t(fld) values('D')
declare @sql varchar(2000)
set @sql = ''
select @sql = @sql + ',' + fld
from #t
set @sql = stuff(@sql,1,1,'')select @sql as Titledrop table #t
insert into #t(fld) values('B')
insert into #t(fld) values('C')
insert into #t(fld) values('D')
declare @sql varchar(2000)
set @sql = ''
select @sql = @sql + ',' + fld
from #t
set @sql = stuff(@sql,1,1,'')select @sql as Titledrop table #t
GO------------
ijklmnabcdef(所影响的行数为 1 行)
(
id int,
name varchar(10)
)insert into tb
select 1,'a'
union alL
select 2,'b'
union alL
select 1,'c'
union alL
select 2,'d'Create function Fun_AA
(@id int)
returns varchar(200)
as
begin
Declare @ReSult varchar(200)
--初始化@ReSult
set @result='' select @result=@result+','+name from tb where id=@id
--去除最前的‘,’
set @result = stuff(@result,1,1,'')
return(@result)
endselect id,dbo.fun_AA(id) from tb
group by id--删除测试用表
drop table tb
drop function fun_AA