I sometimes need to just simply copy a small table to compare it against another run of the same program or some other legitimate reason to copy a table.
This SQL allows creating a new table and populating it with the data from an existing table.
SELECT * INTO dbo.mytableTEST01 FROM (select * from mytable) G1