初学者又来提问：

[pxiaoli]

set @a=1
DECLARE Num_Cursor CURSOR FOR
select number from mobile where state=0 and upline=@upline order by number
OPEN Num_Cursor
FETCH NEXT FROM Num_Cursor
WHILE (@@FETCH_STATUS = 0)
BEGIN
FETCH NEXT FROM Num_Cursor
set @a=@a+1
END
CLOSE Num_Cursor
DEALLOCATE Num_Cursor
select @a

两个问题，１个是在循环中怎么对number字段进行操作，也就是怎么取出来它的值？
第二个问题是如果取不到相对应的记录为什么最后select @a的值会是２，谢谢回答我问题的朋友了！

[marco08]

--1

declare @number int

set @a=1
DECLARE Num_Cursor CURSOR FOR
select number from mobile where state=0 and upline=@upline order by number
OPEN Num_Cursor
FETCH NEXT FROM Num_Cursor into @number
WHILE (@@FETCH_STATUS = 0)
BEGIN
FETCH NEXT FROM Num_Cursor into @number
set @a=@a+1
END
CLOSE Num_Cursor
DEALLOCATE Num_Cursor
select @a

[marco08]

第二个问题是如果取不到相对应的记录为什么最后select @a的值会是２

==
不可能吧

[pxiaoli]

我先谢谢楼上大哥，我的上个问题也是你回答的，我试试去，一会回来再问

[pxiaoli]

如果要是想取两个参数呢？

[marco08]

declare @col1 int, @col2 int

declare cur cursor
for
select col1, col2 from tbName

open cur

fetch next from cur into @col1, @col2

...