SQL Server Insert Data From One Table to another Table

There are times when you need to copy all the content of one table to another for certain reason like backup or so. Doing manual method would take you longer time, hence to ease such task use the sql query to simplify your job:

INSERT INTO new_table (field name1,field name2)
SELECT field name1,field name2
FROM old_table