Exit out of WHILE @@FETCH_STATUS = 0 in db_cursor
14,562
You can use BREAK
to exit a while loop.
Comments
-
Control Freak almost 2 years
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?