Copy data from one table to another table

SQL script to copy data from one table to another table

INSERT INTO newTable
SELECT * FROM oldTable