create function getstr(@content varchar(100))
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+ t2 from a where t1 =@content
select @str=right(@str,len(@str)-1)
return @str
end
goselect distinct t1,dbo..getstr(t1) from a
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+ t2 from a where t1 =@content
select @str=right(@str,len(@str)-1)
return @str
end
goselect distinct t1,dbo..getstr(t1) from a
returns varchar(4000)
as
begin
declare @re varchar(4000)
set @re=''
select @re=@re+','+t2 from tb where t1=@t1
return stuff(@re,1,1,'')
end
go
select t1,dbo.f(t1) as col from tb
如:select里套select或其他