一个关于游标的@@FETCH_STATUS问题
OPEN WK_SELL_DAY_CURSOR

WHILE (@@FETCH_STATUS = 0) BEGIN

FETCH NEXT FROM WK_SELL_DAY_CURSOR Into
@CUSTOMER_CODE,@SIMPLE_NAME,@DEBT_PERIOD,@DEBT_AMOUNT

OPEN WK_SELL_DAY_CURSOR

WHILE (@@FETCH_STATUS = 0) BEGIN

FETCH NEXT FROM WK_SELL_DAY_CURSOR Into @ACCOUNTSET_CODE

...........

END

END

@@FETCH_STATUS是最近一次的FETCH结果,那么有什么办法可以解决嵌套游标@@FETCH_STATUS值的问题???让@@FETCH_STATUS为当前层的游标的@@FETCH_STATUS值??有什么解决办法吗?

等待高人回答,谢谢.

[解决办法]
这个不用吧，嵌套游标在循环时都有BEGIN 和end结束的，我就用了，没什么问题啊
[解决办法]
OPEN WK_SELL_DAY_CURSOR

WHILE (@@FETCH_STATUS = 0) BEGIN

FETCH NEXT FROM WK_SELL_DAY_CURSOR Into
@CUSTOMER_CODE,@SIMPLE_NAME,@DEBT_PERIOD,@DEBT_AMOUNT

OPEN WK_SELL_DAY_CURSOR

WHILE (@@FETCH_STATUS = 0) BEGIN

FETCH NEXT FROM WK_SELL_DAY_CURSOR Into @ACCOUNTSET_CODE

...........

END
CLOSE WK_SELL_DAY_CURSOR--加了这两句
DEALLOCATE WK_SELL_DAY_CURSOR--加了这两句

END
CLOSE WK_SELL_DAY_CURSOR--加了这两句
DEALLOCATE WK_SELL_DAY_CURSOR--加了这两句