SQL Server copy all rows from one table into another i e duplicate table

Question

I want to keep a table as history and replace it with an empty one  How can I do this through Management Studio

User · Answer

Either you can use RAW SQL   INSERT INTO DEST TABLE  Field1  Field2   SELECT Source Field1  Source Field2  FROM SOURCE TABLE   Or use the wizard    Right Click on the Database -  Tasks -  Export Data Select the source target Database Select source target table and fields Copy the data   Then execute   TRUNCATE TABLE SOURCE TABLE

User · Answer

Don t have sql server around to test but I think it s just   insert into newtable select   from oldtable

User · Answer

This will work   select   into DestinationDatabase dbo  TableName1  from   Select   from sourceDatabase dbo  TableName1  Temp

User · Answer

Duplicate your table into a table to be archived   SELECT   INTO ArchiveTable FROM MyTable   Delete all entries in your table   DELETE   FROM MyTable

User · Answer

try this single command to both delete and insert the data   DELETE MyTable     OUTPUT DELETED Col1  DELETED COl2             INTO MyBackupTable   working sample   --set up the tables DECLARE  MyTable table  col1 int  col2 varchar 5   DECLARE  MyBackupTable table  col1 int  col2 varchar 5   INSERT INTO  MyTable VALUES  1  A   INSERT INTO  MyTable VALUES  2  B   INSERT INTO  MyTable VALUES  3  C   INSERT INTO  MyTable VALUES  4  D    --single command that does the delete and inserts DELETE  MyTable     OUTPUT DELETED Col1  DELETED COl2         INTO  MyBackupTable  --show both tables final values select   from  MyTable select   from  MyBackupTable   OUTPUT    1 row s  affected    1 row s  affected    1 row s  affected    1 row s  affected    4 row s  affected  col1        col2 ----------- -----   0 row s  affected   col1        col2 ----------- ----- 1           A 2           B 3           C 4           D   4 row s  affected

User · Answer

select   into x history from your table here  truncate table your table here

[sql] SQL Server copy all rows from one table into another i.e duplicate table

Examples related to sql

Examples related to sql-server-2008

Examples related to ssms