How to copy data from one table into another table when the source table and the destination tables are existing in two different databases in the same server ?
insert into destination-table-name select * from source-table-name
insert into database-name.destination-table-name select * from database-name.source-table-name
insert into database-name.dbo.destination-table-name select * from database-name.dbo.source-table-name
It is not possible to copy data from one table into another when both tables are existing in two different databases .
Back To Top