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
No comments:
Post a Comment