How can I insert values(in table 1) from one database to table 2 in another database ? (SQL)

Question

hi guys ,
i want to ask How can I insert values(in table 1) from one database to table 2 in another database ?

Answer 1

Ramzi Jebalia ,

using google does help sometimes:

https://stackoverflow.com/questions/1612267/move-sql-data-from-one-table-to-another#1612291

Answer 2

Lothar thank youuu

Answer 3

insert into DB2.dbo.table2
select * from db1.dbo.table1