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值??有什么解决办法吗?等待高人回答,谢谢.
@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值??有什么解决办法吗?等待高人回答,谢谢.
当我内层没有数据的时候@@FETCH_STATUS 就等于-1了,再在外层判断@@FETCH_STATUS 的时候就不能再次循环了.
@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 --加了这两句
@CUSTOMER_CODE,@SIMPLE_NAME,@DEBT_PERIOD,@DEBT_AMOUNT OPEN WK_SELL_DAY_CURSOR2
WHILE (@@FETCH_STATUS = 0) BEGIN FETCH NEXT FROM WK_SELL_DAY_CURSOR2 Into @ACCOUNTSET_CODE ........... END
CLOSE WK_SELL_DAY_CURSOR2 --加了这两句
DEALLOCATE WK_SELL_DAY_CURSOR2 --加了这两句 END
CLOSE WK_SELL_DAY_CURSOR1 --加了这两句
DEALLOCATE WK_SELL_DAY_CURSOR1 --加了这两句
应该是这样,复制的时候有点急,所以没有注意,谢谢