Use this to copy a table across two database in the same Sql Server.

select * into [destination database.dbo.destination table]

from [source database.dbo.source table]

 

Example:

select * into Mydatabase2.dbo.employee_backup

from mydatabase1.dbo.employee