Skip to content

SQL Query: Archive Current table to Previous

See post SQL 2005 MA: Export and Delta Import.

truncate table dbo.MyTable_Previous
insert into dbo.MyTable_Previous
select * from dbo.MyTable