SQL Append To Table

This SQL allows appending to an existing table with the data from an another table.

INSERT INTO dbo.mytableTEST01
SELECT * FROM mytable