我想在java代码中执行以下一个函数,但是结果却非常慢,以下的函数,麻烦各位帮我看下是不是可能再做一些优化
CREATE function f_str1(@business_id int)
returns varchar(50)
as
begin
declare @ret varchar(50)
set @ret = ''
select @ret = @ret+','+name from t_tomb_user_info where modify_flag!='d' and tomb_serial =(select tomb_serial from tomb_business where Modify_flag!='D' and business_id=@business_id)
set @ret = stuff(@ret,1,1,'')
return @ret
end
CREATE function f_str1(@business_id int)
returns varchar(50)
as
begin
declare @ret varchar(50)
set @ret = ''
select @ret = @ret+','+name from t_tomb_user_info where modify_flag!='d' and tomb_serial =(select tomb_serial from tomb_business where Modify_flag!='D' and business_id=@business_id)
set @ret = stuff(@ret,1,1,'')
return @ret
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货