I have the following cursor (simple example here) declaration at the top of my SP:

DECLARE @empno int, @salary bigint ;-)

DECLARE C_TOTO CURSOR FOR
SELECT salary
FROM EMPLOYE
WHERE EMPNO = @empno


BEGIN
SET @EMPNO = 1234
OPEN C_TOTO
FETCH NEXT FROM C_TOTO INTO @salary
CLOSE C_TOTO

SET @EMPNO = 5678
FETCH NEXT FROM C_TOTO INTO @salary
CLOSE C_TOTO

DEALLOCATE C_TOTO
END


The problem I ran into is that C_TOTO does not return any rows as if the value of @empno was null.

I want to have a variable driven cursor that takes the value of @empno that changes...

My question: When is @empno evaluated for the cursor definition ?


Thanks!