Exiting WHILE @@ FETCH_STATUS = 0 in db_cursor

Question

Is there any way to exit WHILE @@FETCH_STATUS = 0db_cursor at runtime?

I tried SET @@FETCH_STATUS = 1, but, as I expected, an error occurred. Help?

Answer 1

You can use BREAKto exit the while loop.