Significance of @ fetch_status In the midstream of SQL Server

@ Fetch_status

@ Fetch_status is a global variable of MSSQL.

The return value has the following three meanings: [return type Integer]

-0 fetch statement succeeded

-1 The fetch statement fails or this row is not in the result set.

-2 The extracted row does not exist.

@ Fetch_status the value is changed through fetch next from.

"Fetch next from cursor"

Instance:

The following example uses @ fetch_status to control the cursor activity in a while loop.

Declare employee_cursor cursor

Select lastname, firstname from northwind. DBO. Employees

Open employee_cursor

Fetch next from employee_cursor

While @ fetch_status = 0

Begin

Fetch next from employee_cursor

End

Close employee_cursor

Deallocate employee_cursor