Create function Fun_AA(@name varchar(50))
returns varchar(500)
as
begin
Declare @re varchar(500)
set @re='' select @re=@re+'/'+rtrim(ltrim(desc)) from B where
name=@name if len(@re)>0 select @re=left(@re,len(Re)-1)
return(@re)
endselect * ,dbo.fun_aa(name) from A
returns varchar(500)
as
begin
Declare @re varchar(500)
set @re='' select @re=@re+'/'+rtrim(ltrim(desc)) from B where
name=@name if len(@re)>0 select @re=left(@re,len(Re)-1)
return(@re)
endselect * ,dbo.fun_aa(name) from A
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货