declare cur
open cur
for (;;)
{
fetch cur;
declare cur1;
open cur1;
for(;;)
{
fetch cur1;
........
}
close cur1;
deallocate cur1;
}
close cur;
deallocate cur;
如此的游标嵌套是否可行?
...全文
543打赏收藏
游标的嵌套问题
declare cur open cur for (;;) { fetch cur; declare cur1; open cur1; for(;;) { fetch cur1; ........ } close cur1; deallocate cur1; } close cur; deallocate cur; 如此的游标嵌套是否可行?