一个关于游标的@@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--加了这两句
