Information générale
Forum:
Microsoft SQL Server
Titre:
Cursor variables in SP
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!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement