Query to copy one table to another

Copy data from one table to another in different database

INSERT INTO DestinationDB..MyDestinationTable
SELECT * FROM SourceDB..MySourceTable

Copy data from one table to another in same database

select * into DestinationTablename from SourceTablename