Control Freak
Reputation: 13213
Exit out of WHILE @@FETCH_STATUS = 0 in db_cursor
Is there a way to exit out of the WHILE @@FETCH_STATUS = 0 while performing a db_cursor?
I tried SET @@FETCH_STATUS = 1, but as i expected, an error. Help?
Upvotes: 5
Views: 15765
Answers (1)
Related Questions
- Why is the cursor not terminating?
- How to continue cursor loop even error occured in the loop
- while @@FETCH_STATUS=0 is not working
- SQL Server : stuck in WHILE loop using @@fetch_status
- SQL cursor result in infinite loop
- @@FETCH_STATUS lives outside the cursor
- T-SQL: Cursor iteration not stopping at @@FETCH_STATUS=-1
- sql server cursor stuck in loop
- T-SQL Cursor never ends
- T-Sql cursor not proceeding on fetch