SQL SERVER : 1. SELECT * INTO DEST_TABLE FROM SOUR_TABLE 2. DELETE DEST_TABLE 3. SELECT DEST_TABLE (EMPTY RECORD) 4. INSERT INTO DEST_TABLE SELECT *FROM SOUR_TABLE 5. ALL RECORD IN DEST_TABLE INSERT INTO TABLE2 SELECT * FROM TABLE1 INSERT INTO TABLE2 (COL1, COL2, COL3) SELECT COL1, COL4, COL7 FROM TABLE1 ONE SERVER TO ANOTHER SERVER DATA MOVE IMPORT/EXPORT