这样怎么返回呀！！！！记录集的返回。。

[xiaodian2003]

产品类型
aaa1
aaa2
aaa3
aaa4
返回的结果为aaa1,aaa2,aaa3,aaa4

[txlicenhe]

--1.创建一个合并的函数
create function fmerg()
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+','+cast(pid as varchar) from 表A
set @str=right(@str,len(@str)-1)
return(@str)
End
go

--调用自定义函数得到结果
select dbo.fmerg() from 表A

[CrazyFor]

declare @str varchar (8000)
set @str=''
select @str=@str+产品类型 +',' from 表
print @str

[pengdali]

declare @a varchar(8000)
set @a=''
select @a=@a+','+产品类型 from 表

select right(@a,len(@a)-1)

[dafu71]

declare @str varchar (8000)
set @str=''
select @str=@str+rtrim(产品类型) +',' from 表
set @str=right(@str,len(@str)-1)
print @str

[zjcxc]

declare @ql varchar (8000)
set @ql=''
select @ql=@ql+','+产品类型 from 表
set @sql=substring(@sql,2,8000)
print @str

[xiaodian2003]

谢了

[z5wjz]

declare @var varchar(80),@var1 int,@count int
set @var1 =1
create table #aa
(lx varchar(8000))
select @count=count(*) from yourtable


while @var1<=@count
begin
select @var=产品类型
from yourtable
where id=@var1



if @var1=1
begin
insert into #aa values ( @var )
end
else
begin


update #aa set lx=lx + @var
update #aa
set lx=lx+','
end
set @var1=@var1+1
end
select * from #aa
drop table #aa