1. Este site usa cookies. Ao continuar a usar este site está a concordar com o nosso uso de cookies. Saber Mais.

Criar Tabela no SQL a partir do comando Select

Discussão em 'Programação' iniciada por AndreVSerafim, 31 de Março de 2009. (Respostas: 7; Visualizações: 6600)

  1. AndreVSerafim

    AndreVSerafim Power Member

    A ver se é desta que me conseguem ajudar xD

    Alguem sabe como se cria uma tabela no SQL apartir do comando select?
    Código:
    [/COLOR][SIZE=2][SIZE=2]
    [COLOR=white]select[/COLOR][/SIZE][/SIZE][COLOR=white][SIZE=2] @pNota1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] Nota1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pNota2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] Nota2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pAgendaB [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] AgendaB[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pAgendaN [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] AgendaN[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pAgenda1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] Agenda1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pAgenda2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] Agenda2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pAgenda3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] Agenda3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pAgenda4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] Agenda4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pAgenda5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] Agenda5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pAgenda6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] Agenda6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2]@pMBQuotasB [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] MBB[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pMBQuotasN [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] MBN[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pDDQuotasB [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] DDB[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pDDQuotasN [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] DDN[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pVISAQuotasB [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] VISAB[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pVISAQuotasN [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] VISAN[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pPontosS3G_B [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] PB[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pPontosS3G_N [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] PN[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIdTab1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] TB1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntDe1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IND1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntA1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] INA1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1D1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1D1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1P1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1P1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2D1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2D1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2P1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2P1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3D1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3D1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3P1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3P1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt1_Imagem1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1I1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt1_Imagem2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2I1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt1_Imagem3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3I1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIdTab2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] TB2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntDe2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IND2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntA2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] INA2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1D2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1D2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1P2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1P2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2D2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2D2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2P2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2P2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3D2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3D2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3P2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3P2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt2_Imagem1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1I2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt2_Imagem2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2I2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt2_Imagem3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3I2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIdTab3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] TB3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntDe3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IND3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntA3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] INA3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1D3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1D3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1P3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1P3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2D3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2D3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2P3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2P3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3D3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3D3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3P3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3P3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt3_Imagem1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1I3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt3_Imagem2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2I3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt3_Imagem3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3I3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIdTab4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] TB4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntDe4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IND4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntA4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] INA4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1D4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1D4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1P4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1P4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2D4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2D4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2P4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2P4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3D4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3D4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3P4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3P4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt4_Imagem1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1I4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt4_Imagem2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2I4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt4_Imagem3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3I4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIdTab5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] TB5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntDe5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IND5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntA5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] INA5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1D5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1D5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1P5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1P5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2D5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2D5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2P5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2P5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3D5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3D5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3P5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3P5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt5_Imagem1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1I5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt5_Imagem2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2I5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt5_Imagem3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3I5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIdTab6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] TB6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntDe6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IND6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntA6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] INA6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1D6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1D6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1P6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1P6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2D6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2D6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2P6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2P6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3D6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3D6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3P6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3P6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt6_Imagem1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1I6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt6_Imagem2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2I6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt6_Imagem3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3I6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIdTab7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] TB7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntDe7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IND7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntA7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] INA7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1D7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1D7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1P7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1P7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2D7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2D7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2P7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2P7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3D7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3D7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3P7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3P7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt7_Imagem1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1I7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt7_Imagem2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2I7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt7_Imagem3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][/COLOR][SIZE=2][COLOR=white] IN3I7[/COLOR]
    [/SIZE][COLOR=white]


    O select é esse agora so nao sei como vou conseguir a tabela para tudo isso XX
     
  2. ribeiro55

    ribeiro55 Power Member

    Do que eu conheço, não crias tabelas através de um SELECT, mas de um CREATE
     
  3. AndreVSerafim

    AndreVSerafim Power Member

    LOOL sim eu sei XX mas da para defenir os campos atraves do select e é isso que eu nao sei
     
  4. ribeiro55

    ribeiro55 Power Member

    Julgo que não... por isso é que existe um CREATE e um SELECT... :001:
    Posso não estar a perceber o que queres, talvez alguém que passe por aí tenha algo a dizer.
     
  5. oscarolim

    oscarolim Power Member

    Podes criar tabelas temporarias.

    SELECT * FROM table AS t1
     
  6. Tomb4000

    Tomb4000 Power Member

    Create Table 'COISO' as Select campo_1, campo_2 .... from nome_tabela;

    Create Table 'COISO2' as Select que quiseres...

    Cria estrutura e adiciona dados resultantes do select.

    "Se for isso é isto." :paranoid::freak3:

    -isto em oracle
     
    Última edição: 31 de Março de 2009
  7. AndreVSerafim

    AndreVSerafim Power Member

    Obrigado pela ajuda de todos acho que nunca tinham respondido tanto a um topico meu xD

    Código:
    select[COLOR=white][SIZE=2] @pNota1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] Nota1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pNota2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] Nota2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pAgendaB [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] AgendaB[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pAgendaN [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] AgendaN[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pAgenda1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] Agenda1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pAgenda2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] Agenda2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pAgenda3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] Agenda3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pAgenda4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] Agenda4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pAgenda5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] Agenda5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pAgenda6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] Agenda6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2]@pMBQuotasB [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] MBB[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pMBQuotasN [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] MBN[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pDDQuotasB [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] DDB[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pDDQuotasN [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] DDN[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pVISAQuotasB [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] VISAB[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pVISAQuotasN [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] VISAN[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pPontosS3G_B [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] PB[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pPontosS3G_N [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] PN[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIdTab1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] TB1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntDe1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IND1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntA1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] INA1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1D1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1D1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1P1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1P1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2D1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2D1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2P1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2P1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3D1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3D1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3P1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3P1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt1_Imagem1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1I1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt1_Imagem2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2I1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt1_Imagem3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3I1[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIdTab2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] TB2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntDe2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IND2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntA2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] INA2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1D2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1D2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1P2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1P2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2D2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2D2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2P2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2P2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3D2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3D2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3P2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3P2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt2_Imagem1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1I2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt2_Imagem2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2I2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt2_Imagem3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3I2[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIdTab3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] TB3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntDe3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IND3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntA3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] INA3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1D3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1D3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1P3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1P3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2D3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2D3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2P3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2P3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3D3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3D3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3P3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3P3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt3_Imagem1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1I3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt3_Imagem2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2I3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt3_Imagem3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3I3[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIdTab4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] TB4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntDe4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IND4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntA4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] INA4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1D4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1D4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1P4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1P4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2D4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2D4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2P4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2P4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3D4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3D4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3P4 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3P4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt4_Imagem1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1I4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt4_Imagem2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2I4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt4_Imagem3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3I4[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIdTab5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] TB5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntDe5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IND5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntA5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] INA5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1D5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1D5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1P5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1P5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2D5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2D5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2P5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2P5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3D5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3D5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3P5 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3P5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt5_Imagem1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1I5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt5_Imagem2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2I5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt5_Imagem3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3I5[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIdTab6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] TB6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntDe6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IND6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntA6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] INA6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1D6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1D6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1P6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1P6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2D6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2D6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2P6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2P6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3D6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3D6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3P6 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3P6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt6_Imagem1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1I6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt6_Imagem2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2I6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt6_Imagem3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3I6[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIdTab7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] TB7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntDe7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IND7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pIntA7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] INA7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1D7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1D7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_1P7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1P7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2D7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2D7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_2P7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2P7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3D7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3D7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt_3P7 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN3P7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt7_Imagem1 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN1I7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt7_Imagem2 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][SIZE=2] IN2I7[/SIZE][SIZE=2][SIZE=2],[/SIZE][/SIZE][SIZE=2] @pInt7_Imagem3 [/SIZE][SIZE=2][SIZE=2]as[/SIZE][/SIZE][/COLOR][SIZE=2][COLOR=white] IN3I7[/COLOR]
    [/SIZE]into TabelaNova
    Isto faz milagres xD
     
  8. Thorak

    Thorak Power Member

    Eu acho que o que tu queres é isto:

    Select * into tabela_final from tabela_original


    Cria-te uma nova tabela igualzinha à anterior. É possível criar com joins e clausulas where se por acaso te interessar

    Ups, esquece, n reparei no último post onde ja estava respondida a pergunta....
     

Partilhar esta Página