How to copy data from one table to another (two libraries are not on the same computer)

Format

SELECT * Into table from OPENROWSET (' SQLOLEDB ', ' SQL Server name '; ' User name '; ' Password ', database name. dbo. Table name)

Such as:

 
SELECT *Into U1club_sysitem_set from OpenRowset (' SQLOLEDB ',' 192.168.1.133 ';' Sa '; ' 123456 ', u1club.dbo.u1club_sysitem_set)

The second way: if the data structure of the two tables is the same,

Insert into u1club_sysitem_set select * FROM OpenRowset (' SQLOLEDB ',' 192.168.1.133 ';') Sa '; ' 123456 ', u1club.dbo.u1club_sysitem_set)

If the data structure is not the same

Insert Into u1club_sysitem_set (ID,name) Select ID,name from OpenRowset (' SQLOLEDB ',' 192.168.1.133 '; ' sa '; ' 123456 ', u1club.dbo.u1club_sysitem_set)

How to copy data from one table to another (two libraries are not on the same computer)