sqlserver function(函数) 字符串累加

概述ALTER FUNCTION dbo.getsearchname(@partnumber varchar(30))RETURNS varchar(8000)ASBEGINdeclare @ret varchar(8000)select @ret= '' declare cur_res cursor for select DISTINCT A_search

ALTER  FUNCTION dbo.getsearchname(@partnumber varchar(30))RETURNS varchar(8000)ASBEGINdeclare @ret varchar(8000)select @ret= '' declare cur_res cursor  for select disTINCT A_searchname from PurchaSEOrder where partnumber=@partnumberopen cur_resdeclare @temp varchar(50)FETCH NEXT FROM cur_res INTO @tempwhile @@FETCH_STATUS=0beginselect @ret=@temp+','+@retFETCH NEXT FROM cur_res INTO @tempendCLOSE cur_resDEALLOCATE cur_resif len(@ret) > 1   select @ret = substring(@ret,1,len(@ret)-1) return @ret return @retendselect dbo.getsearchname('744777147')

总结

以上是内存溢出为你收集整理的sqlserver function(函数) 字符串累加全部内容，希望文章能够帮你解决sqlserver function(函数) 字符串累加所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。