@@fetch_status值老不定？

[dongkuang]

declare yb SCROLL CURSOR for
select id from equipment where equipment.id between @beginsid and @endsid order by equipment.sid
open yb
while @@fetch_status=0
begin
fetch next from yb into @@id
insert into equipmentysdtemp(equipmentsid,equipmentsidgo)
values(@beginsid,@@fetch_status)
continue
end
close yb
deallocate yb

用asp.net调用此存储过程，过几分钟第一次试就正常，以后连续试都擦入空白，经测试，是@@fetch_status值老不定，不知为什么？

[zlp321002]

--try
declare yb SCROLL CURSOR for
select id from equipment where equipment.id between @beginsid and @endsid order by equipment.sid
open yb
while @@fetch_status=0
begin
insert into equipmentysdtemp(equipmentsid,equipmentsidgo)
values(@beginsid,@@fetch_status)
fetch next from yb into @@id
end
close yb
deallocate yb

[zlp321002]

--try
declare yb SCROLL CURSOR for
select id from equipment where equipment.id between @beginsid and @endsid order by equipment.sid
open yb
Fetch yb Into @@id
while @@fetch_status=0
begin
insert into equipmentysdtemp(equipmentsid,equipmentsidgo)
values(@beginsid,@@fetch_status)
Fetch yb Into @@id
end
close yb
deallocate yb

[dongkuang]

这个我知道，就是想知道为啥@@fetch_status值老不定？因为我以前的系统这样用的，没问题，为啥现在有，是不是都要改

[-渔民-]

學習

[wgsasd311]

--楼主范了逻辑错误,应是先取值,再判断游标状态,试下面
--try
declare yb SCROLL CURSOR for
select id from equipment where equipment.id between @beginsid and @endsid order by equipment.sid
open yb
fetch next from yb into @@id
while @@fetch_status=0
begin
insert into equipmentysdtemp(equipmentsid,equipmentsidgo)
values(@beginsid,@@fetch_status)
fetch next from yb into @@id
end
close yb
deallocate yb

[mislrb]

同意楼上

[zjcxc]

楼主的逻辑有问题
fetch 是取下一条数据, 取数据是否成功, 这个是未知的, 要通过@@fetch_status来判断.
而楼主在fetch后就直接插入了, 并没有理会fetch是否成功, 结果当然会有问题.

[msjqd]

同意 邹建老大