主页
基础类
应用实例
新技术前沿

哪的错啊请问

wuhaozhiyuan 2007-12-01 02:04:02

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

...全文

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

dawugui 2007-12-02

知道原因就好。

回复赞

wuhaozhiyuan 2007-12-01

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

回复赞

fa_ge 2007-12-01



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