请问存储过程中对于两层循环的游标, 条件while @@fetch_status = 0 在内、外层一样的用有没有冲突?

[wh1977]

declare cur1 cursor local fast_forward for select ....
open cur1
fetch next from cur1 into ...


while @@fetch_status = 0
------------开始循环1------------------------
begin


declare cur2 cursor local fast_forward for select ....
open cur2
fetch next from cur2 into ...


while @@fetch_status = 0
------------开始循环2------------------------
begin


end


end

[wzy_love_sly]

上个fetch的

[昵称被占用了]

只要保证
while @@fetch_status = 0
在正确的
fetch next ...
后执行

就没问题