The use of the SQL midstream standard is a

@ @fetch_status

DECLARE @id int

Set @id = 1

DECLARE Cur1 CURSOR for
SELECT EmployeeID

From #table

OPEN Cur1;
FETCH NEXT from Cur1;
While @ @FETCH_STATUS = 0 and @id = 0
BEGIN
FETCH NEXT from Cur1;
END;
CLOSE Cur1;
Deallocate Cur1;
GO

There is a problem with the bold sentence in the above example, when the value of the first value @id in the cursor does not meet the criteria, the @ @fetch_status value will not be 0.

Note:

return value  
0  FETCH statement succeeded.   
The -1  FETCH statement failed or the row is not in the result set.   
-2  The fetched row does not exist.

The use of the SQL midstream standard is a