create function getstr(@content int)
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(contect) from Mytable where ID=@content
select @str=right(@str,len(@str)-1)
return @str
end
go--调用:
select ID,dbo.getstr(ID) contect from Mytable group by id
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(contect) from Mytable where ID=@content
select @str=right(@str,len(@str)-1)
return @str
end
go--调用:
select ID,dbo.getstr(ID) contect from Mytable group by id
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+fBookName from tTest where fUserName=@content
select @str=right(@str,len(@str)-1)
return @str
end
go--调用:
select fUserName,dbo.getstr(fUserName) fUserName from tTest group by fUserName
http://expert.csdn.net/Expert/topic/2123/2123698.xml?temp=.3942987
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+fBookName from Mytable where fUserName=@content
select @str=right(@str,len(@str)-1)
return @str
end
go--调用:
select fUserName,dbo.getstr(fUserName) fUserName from Mytable group by fUserName
declare @a varchar(10),@b varchar(8000)
update #t set @b=case @a when fUserName then @b+fBookName else fBookName end
,fBookName=@b,@a=fUserName select fUserName,fBookName=max(aa) from #t group by fUserName
drop table #t
declare @a varchar(10),@b varchar(8000)
update #t set @b=case @a when fUserName then @b+fBookName else fBookName end
,aa=@b,@a=fUserName select fUserName,fBookName=max(aa) from #t group by fUserName
drop table #t
[交流]行列转换
[交流]行列转换
这个帖子里讲的很详细