初学者又来提问：
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的值会是２，谢谢回答我问题的朋友了！

[解决办法]
--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