关于游标的问题

Question

Open sp_select 
    Fetch Next From sp_select Into @bid,@buyer_no,@buyer_name,@link_man,@btel,@address,@post
    
    While @@Fetch_Status = 0
    
    Begin
    
        Insert Into #tmp([id],[buyer_no],[buyer_name],[link_man],tel,[address],[post])
        Values(@bid,@buyer_no,@buyer_name,@link_man,@btel,@address,@post)
    
    End 
    
    Close sp_select
    Deallocate sp_select这里整了个死循环。
while里加个fetch.

Answer 1

呵呵，还是不大明白，能说详细点吗，在哪里添加Fetch,谢谢

Answer 2

Open sp_select 
Fetch Next From sp_select Into @bid,@buyer_no,@buyer_name,@link_man,@btel,@address,@postWhile @@Fetch_Status = 0Begin    Insert Into #tmp([id],[buyer_no],[buyer_name],[link_man],tel,[address],[post])
    Values(@bid,@buyer_no,@buyer_name,@link_man,@btel,@address,@post)

Fetch Next From sp_select Into @bid,@buyer_no,@buyer_name,@link_man,@btel,@address,@postEnd 
    
Close sp_select
Deallocate sp_select

Answer 3

两个while都没fetch...双重死循环