sqlserver function(函数) 字符串累加

ALTER  FUNCTION dbo.getsearchname(@partnumber varchar(30))
RETURNS varchar(8000)
AS
BEGIN

declare @ret varchar(8000)
select @ret= '' 

declare cur_res cursor  for 

select DISTINCT A_searchname from PurchaSEOrder where partnumber=@partnumber

open cur_res

declare @temp varchar(50)

FETCH NEXT FROM cur_res INTO @temp

while @@FETCH_STATUS=0

begin

select @ret=@temp+','+@ret


FETCH NEXT FROM cur_res INTO @temp
end

CLOSE cur_res
DEALLOCATE cur_res

if len(@ret) > 1 
  select @ret = substring(@ret,1,len(@ret)-1) 
return @ret 


return @ret

end


select dbo.getsearchname('744777147')

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!