O GoConqr está de visual novo! Conte para nós o que você achou.

Registre-se grátis

Quiz

Cursores

Inguelberth Garcia 10 perguntas

Fazer o quiz

Perguntas do 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

Informações

Descrição
Quiz sobre Cursores, criado por Inguelberth Garcia em 19-02-2014.
Idioma
Español
Visualizações
174
Etiquetas
sql
Avaliação
Ainda sem avaliações
Avalie este quiz
Avalie este quiz

Fale Conosco

Sobre o que é sua mensagem?

O que você acha do novo visual?

Você gostou?