insert into TestDestination.dbo.Employee (Column1, Column2, ...)
select (Column1, Column2, ...) from TestSource.dbo.Employee
This will create a new table in TestDestination database
select (Column1, Column2, ...) into Employee from TestSource.dbo.Employee