create function getstr(@content varchar(20))
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''select @str=@str+';'+fld2+'-'+cast(fld3 as varchar(10)) from test where fld1=@contentset @str=right(@str,len(@str)-1)return @str
end
go--语句:
select distinct fld1,dbo.getstr(fld1) from test
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''select @str=@str+';'+fld2+'-'+cast(fld3 as varchar(10)) from test where fld1=@contentset @str=right(@str,len(@str)-1)return @str
end
go--语句:
select distinct fld1,dbo.getstr(fld1) from test
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货