GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

Cursores

Inguelberth Garcia 10 questions

Take the quiz

Questions in this quiz (10)

  1. 1/*
    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
    1. A1,3,5
    2. B1,2,3,4,5
    3. C1,4,5
    4. D1,2,2,3
    5. E1,2,4
    6. F1,2,3
  2. 2/*
    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!"
    1. A:D
      TERMINO!
    2. B:D
      :D
      :D
      TERMINO!
    3. C:D
      TERMINO!
      :D
      TERMINO!
      :D
      TERMINO!
    4. D:D
      :D
      :D
      :D
      .......
      Infinito
  3. 3/*
    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
    1. A1, 3, 5, 7, 9, 11
    2. B3, 5, 7, 9, 11
    3. C0, 3, 5, 7, 9, 11
    4. D2,4,6,8,10
    5. E21,41,61,81,101
  4. 4/*
    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
    1. AHijo: Marcos Y Nieto: Luis
    2. BHijo: Luis Y Nieto: Marcos
    3. CHijo: Andres Y Nieto: Luis
    4. DHijo: Marcos Y Nieto: Marcos
  5. 5/*
    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
    1. A4,8,12,16,20
    2. B2,4,6,8,10,12,14,16,18,20
    3. C4,6,10,16,20
    4. D2,4,8,10,16,20
    5. E4,8,10,12,20
  6. 6CREATE PROCEDURE ProcesarNumero @numero INT
    AS
    BEGIN
    PRINT @numero%2=0
    END
    GO
    EXEC ProcesarNumero 80
    1. ATRUE
    2. BFALSE
    3. C0
    4. D40
    5. E2
  7. 71) DELETE
    2) *
    3) [NombreTabla]
    4) WHERE [condicion]
    5) [Campo]
    6) FROM
    1. A1,6,3,4
    2. B1,2,6,3
    3. C1,2,6,3,4
    4. D1,3,6,3,5
    5. E1,3,6,3,5,4
    6. F1,3,4,5
  8. 8/*
    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. A6
    2. B7
    3. C1,2,3,4,5,6
    4. DError
    5. E5
  9. 91)UPDATE
    2)SET
    3)FROM
    4)WHERE [Condicion]
    5)[Tabla]
    6)[Campo]=[Valor]
    7)VALUES
    1. A1,5,2,6,4
    2. B1,5,3,6,4
    3. C1,5,7,6,4
    4. D1,3,5,7,6,4
    5. E1,3,5,6,4
  10. 10/*
    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
    1. A1.1
      2.4
      3.7
    2. B1.3
      2.6
    3. C1.1
      2.3
      3.6
    4. D1.2
      2.6
      3.7

Information

Description
Quiz on Cursores, created by Inguelberth Garcia on 19/02/2014.
Language
Español
Views
174
Tags
sql
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?