Cursores

/* NumeroReal 1 2 3 4 5 */ DECLARE @numero INT DECLARE cCursor CURSOR FOR SELECT numero FROM NumeroReal OPEN cCursor FETCH cCursor INTO @numero WHILE (@@FETCH_STATUS=0) BEGIN PRINT @numero FETCH cCursor INTO @numero FETCH cCursor INTO @numero END

/* NumeroDOS 2 4 6 */ DECLARE @numero INT DECLARE cCursor CURSOR FOR SELECT numero FROM NumeroDOS OPEN cCursor FETCH cCursor INTO @numero FETCH cCursor INTO @numero FETCH cCursor INTO @numero FETCH cCursor INTO @numero WHILE (@@FETCH_STATUS=-1) BEGIN PRINT ':D' FETCH cCursor INTO @numero END PRINT "TERMINO!"

/* NumeroDOS 2 4 6 8 10 */ DECLARE @numero INT, @interuptor BIT DECLARE cCursor CURSOR FOR SELECT numero FROM NumeroDOS OPEN cCursor SET @interuptor=0 WHILE (@@FETCH_STATUS=0 OR @interuptor=0) BEGIN SET @interuptor=1 PRINT @numero+1 FETCH cCursor INTO @numero END

/* Abuelo 1 Andres 2 Ricardo 3 Eduardo Padres 1 Juan abu:3 2 Luis abu:1 3 Marcos abu:2 Hijos 1 Marcos Papa:2 2 Andrea Papa:1 3 Lucas Papa:3 */ DECLARE @nombre VARCHAR(255) DECLARE cCursor CURSOR FOR SELECT nombre FROM Padres INNER JOIN Abuelo ON Padre.idAbu=Abuelo.idAbu WHERE Abuelo.nombre='Andres' OPEN cCursor FETCH cCursor INTO @nombre WHILE (@@FETCH_STATUS=0) BEGIN DECLARE @nombreN VARCHAR(255) DECLARE cCursorN CURSOR FOR SELECT nombre FROM Hijos INNER JOIN Padres ON Hijos.idPa=Padres.idPa WHERE Padres.nombre=@nombre OPEN cCursorN FETCH cCursorN INTO @nombreN WHILE(@@FETCH_STATUS=0) BEGIN PRINT ' Hijo: '+@nombreN+' Y Nieto: '+@nombre FETCH cCursorN INTO @nombreN END CLOSE cCursorN DEALLOCATE cCursorN FETCH cCursor INTO @nombre END

/* NUMEROS 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20 */ DECLARE @numero INT DECLARE cCursor CURSOR FOR SELECT numero FROM NUMEROS WHERE numero%2=0 OPEN cCursor FETCH cCursor INTO @numero FETCH cCursor INTO @numero WHILE (@@FETCH_STATUS=0) BEGIN PRINT @numero FETCH cCursor INTO @numero FETCH cCursor INTO @numero END

CREATE PROCEDURE ProcesarNumero @numero INT AS BEGIN PRINT @numero%2=0 END GO EXEC ProcesarNumero 80

1) DELETE 2) * 3) [NombreTabla] 4) WHERE [condicion] 5) [Campo] 6) FROM

/* NUMEROS 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20 */ DECLARE @numero INT DECLARE cCursor CURSOR FOR SELECT numero FROM NUMEROS OPEN cCursor FETCH cCursor INTO @numero FETCH cCursor INTO @numero FETCH cCursor INTO @numero FETCH cCursor INTO @numero FETCH cCursor INTO @numero FETCH cCursor INTO @numero PRINT @numero

1)UPDATE 2)SET 3)FROM 4)WHERE [Condicion] 5)[Tabla] 6)[Campo]=[Valor] 7)VALUES

/* NUMEROS 1,2,3,4,5,6,7,8,9,10 DECIMALES 0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,0.0 */ DECLARE @numero INT DECLARE cCursor CURSOR FOR SELECT numero FROM NUMEROS OPEN cCursor FETCH cCursor INTO @numero DECLARE @numeroD NUMERIC(2,1) DECLARE cCursorD CURSOR FOR SELECT numero FROM DECIMALES OPEN cCursorD FETCH cCursorD INTO @numeroD WHILE (@@FETCH_STATUS=0) BEGIN PRINT @numero+@numeroD FETCH cCursor INTO @numero FETCH cCursorD INTO @numeroD FETCH cCursorD INTO @numeroD FETCH cCursorD INTO @numeroD END