Advertisement
econz

Firebird - Lendo dados de uma base e escrevendo em outra

May 4th, 2016
199
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.48 KB | None | 0 0
  1. EXECUTE block
  2. AS
  3. DECLARE variable vi_CodEmpresa INTEGER;
  4. DECLARE variable vs_Nome       VARCHAR(100);
  5. BEGIN
  6.  
  7.    FOR
  8.       SELECT
  9.          CODEMPRESA,
  10.          NOME
  11.       FROM EMPRESA
  12.       INTO
  13.          :vi_CodEmpresa,
  14.          :vs_Nome
  15.    do BEGIN
  16.  
  17.       EXECUTE statement 'insert into ALUNO (ID,NOME) values ('||:vi_CodEmpresa||',''' || :vs_Nome || ''')'
  18.          ON external DATA SOURCE 'C:\CAMINHO_DESTINO\DADOS.FDB' AS USER 'sysdba' PASSWORD 'masterkey';
  19.  
  20.    END
  21.  
  22. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement