Exit out of WHILE @@FETCH_STATUS = 0 in db_cursor

Question

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?

Answer 1

You can use BREAK to exit a while loop.