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_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')