Sql 入门

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

 

 

Duplicate your table into a table to be archived：

SELECT * INTO ArchiveTable FROM MyTable

Don't have sql server around to test but I think it's just:

insert into newtable select * from oldtable;