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')
sqlserver function(函数) 字符串累加
最新推荐文章于 2024-05-15 19:59:01 发布