SQL cross-database transfer

The same structure.
INSERT INTO Database A.dbo.tablea
SELECT * FROM Database B.dbo.tablea

Other than that:
Nsert into DDD (Field 1, Field 2, Field 3 ...)
(
Select field 1, Field 2, Field 3 .... from AAA,BBB,CCC
)
The fields that you insert and the number of fields in the query are of the same type
As your library query is inserted
So add the library name before the table name. User Name
Insert INTO B. User. DDD (field 1, Field 2, Field 3 ...)
(
Select field 1, Field 2, Field 3 .... from A. User. aaa,a. user. bbb,a. User. CCC
)
If it is a SQL Server database, you can see the table user name in the left menu of Query Analyzer.
If you are operating under a library, you can omit the library name of the A library table. User name, same as B library table

Reprinted from: http://www.aspnetjia.com/Cont-128.html

SQL cross-database transfer