Charles Reitz [Minhas Anotações]

SELECT A1_CGC,A1_NOME,A1_COD,AC8_CODCON,AC8_CODENT,A1_EMAIL,A1_TEL,A1_TELEX,A1_FAX FROM SA1010 LEFT OUTER JOIN AC8010 ON A1_COD+A1_LOJA = AC8_CODENT AND AC8010.D_E_L_E_T_ <> '*' AND SA1010.D_E_L_E_T_ <> '*' WHERE AC8_CODCON IS NULL AND AC8_CODENT IS NULL

Fazer backup da tabela 1 SELECT   * 2 INTO   BackupTable 3 FROM   MyTable Fonte: http://www.atma-it.com/2012/04/16/rapidinhas-fazer-backup-de-tabela-no-sql-server/

UPDATE SZ4020 SET Z4_VEND1 = '999999' FROM SZ4020 INNER JOIN SZ5020 ON SZ4020.Z4_NUMCTR = SZ5020.Z5_NUMCTR WHERE Z4_CLIENTE BETWEEN '001385' AND '002621' UPDATE SZ5020 SET Z5_GERCOM = '2' FROM SZ5020 INNER JOIN SZ4020 ON SZ5020.Z5_NUMCTR = SZ4020.Z4_NUMCTR WHERE Z4_CLIENTE BETWEEN '001385' AND '002621' **********************Verificações ******************* Select * from SZ4020 WHERE Z4_VEND1 = '' SELECT * FROM SZ4020 INNER JOIN SZ5020 ON SZ4020.Z4_NUMCTR = SZ5020.Z5_NUMCTR WHERE Z4_CLIENTE BETWEEN '001385' AND '002621' SELECT * FROM SZ5020