DECLARE @IDALUMNO INT = 0;

 

DECLARE C_ALUMNOS CURSOR FOR SELECT ID_ALUMNO FROM ALUMNOS;

OPEN C_ALUMNOS;

FETCH NEXT FROM C_ALUMNOS INTO @IDALUMNO;

WHILE @@FETCH_STATUS = 0

BEGIN

                PRINT @IDALUMNO;

FETCH NEXT FROM C_ALUMNOS INTO @IDALUMNO;

END;

CLOSE C_ALUMNOS;

DEALLOCATE C_ALUMNOS;