哪的错啊请问

[wuhaozhiyuan]

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

alter function getProductList(@customerguid char(36)) returns varchar(1024) as
begin
declare @product varchar(50)
declare @ReturnListProduct varchar(1024)
declare @ReturnListProductTemp varchar(300)
declare @fuhao char(1)
declare Product_list cursor for select p.productdesc from customer_surrogate cs left join product p on cs.productid = p.product_id
where cs.customer_guid = @customerguid

open Product_list;
--+ltrim(rtrim(@Currkey))+('''')
begin

while(1=1)
begin
fetch Product_list into @product
if @@fetch_status=-1
break

else
begin
select @ReturnListProductTemp=@ReturnListProduct
select @ReturnListProduct=ltrim(rtrim(@product))+','+@ReturnListProductTemp
end
end

end

close Product_list
return @ReturnListProduct
end

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

[fa_ge]

报什么错?

[sunhonglei2004]

没有看到有报错,还是以上语句没有达到LZ想要的效果

[fa_ge]

open   Product_list; 
  --+ltrim(rtrim(@Currkey))+('''') 
    begin 
                            
          while(1=1) 
          begin 
            fetch next  Product_list   into   @product 
            if   @@fetch_status=-1 
                 break 
                                      
            else   
                begin 
                   select   @ReturnListProductTemp=@ReturnListProduct 
                   select   @ReturnListProduct=ltrim(rtrim(@product)               +','+@ReturnListProductTemp 
                end 
           fetch  next Product_list   into   @product --这里少了这句，不然while是个死循环
          end                   
                            
    end 
            
close   Product_list 

[wuhaozhiyuan]

我知道了 是因为变量没有负初始值 所以负不上值.

[dawugui]

知道原因就好。