how to copy data from one table to another table in another database

Answer:

select * into desti.dbo.new from sourc.dbo.table;

here in above query
desti means name of the database where you want to create new table.
new means name of the new table in which you copy the data.
source means name of the database from where your table is located.

table means name of the table from which you take the data for copying.
dbo means database object