Below query transfers all the data from employee table of testsource database
to employee table of testdestination database
insert into TestDestination.dbo.Employee
select * from TestSource.dbo.Employee
for the specific data to transfer you will add where clause for the select as follows
insert into TestDestination.dbo.Employee
select * from TestSource.dbo.Employee
Where Id > 10 and Id < 20