怎么跳出游标循环?
declare AutoAudit_cursor cursor for
select AuditHistoryId,FlowId
from AuditingHistory
where BillId=@BillId
open AutoAudit_cursor
fetch next from AutoAudit_cursor
into @AuditHistoryId,@FlowId
while @@FETCH_STATUS<>-1
begin
exec(dosomething……)
fetch next from AutoAudit_cursor
into @AuditHistoryId,@FlowId
end
CLOSE AutoAudit_cursor
DEALLOCATE AutoAudit_cursor
循环里面有很多行,执行用exec来执行,想问一下当达到条件之后怎么终止游标循环