how to copy data from one table to another in sql?

--how to copy data from one table to another in sql
insert into TableName 
select * from AnotherTABLE
--here Tablename is already created
--another way of copying data but here we should create temp table
select * into NEWTABLE
from OLDTABLE