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

Pessoal, estava com um problema no TDS, pesquisei na WEB e achei uma solução ao qual para mim funcionou.  Erro: Could not reserve enough space for object heap Solução: Adicionar os parametros no developerstudio.ini -XX:MaxHeapSize=256m -Xmx512m Referencia:  http://stackoverflow.com/questions/4401396/could-not-reserve-enough-space-for-object-heap

Documentação: http://serverfault.com/questions/24622/how-to-use-rsync-over-ftp http://aurelianomartins.wordpress.com/2010/09/19/copias-remotas-de-arquivos/

mysql -u USUARIO -pSUASENHA SEUBANCODEDADOS < NOMEDOARQUIVO.sql

dd if=/dev/zero of=/var/swap.1 bs=1M count=1024 mkswap /var/swap.1 swapon /var/swap.1