Drill-down to SQL Server queries across databases _mssql

Statement
SELECT * from database a.dbo. Table A, database b.dbo. Table b b WHERE A.field=b.field
The "DBO" can omit such
SELECT * from Database A.. Table A A, database B.. Table b b WHERE A.field=b.field

SQL Server database:
--This is a map of a remote database
EXEC sp_addlinkedserver ' remote database IP or host name ', N ' SQL Server '
--This is a login to the remote database
EXEC sp_addlinkedsrvlogin ' remote database IP or host name ', ' false ', NULL, ' login ', ' password '
--After logging in, you can manipulate objects in the remote database in the following format
SELECT * FROM [IP or host name of remote database]. [Database name]. [dbo]. [Table name]
INSERT INTO OPENROWSET (' SQLOLEDB ', ' 192.168.0.100 '; Sa '; ' 10060 ', ' select * from Knss2009.dbo.yw_kck ') SELECT * from Yw_kck

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Data operations between different server databases
--Create a linked server
exec sp_addlinkedserver ' itsv ', ', ' SQLOLEDB ', ' Remote server name or IP address '
exec sp_addlinkedsrvlogin ' itsv ', ' false ', NULL, ' username ', ' password '
--Query sample
SELECT * from ITSV. Database name. dbo. Table name
--Import sample
SELECT * into table from ITSV. Database name. dbo. Table name
--delete linked server when no longer in use
exec sp_dropserver ' itsv ', ' droplogins '
--Connect remote/LAN data (Openrowset/openquery/opendatasource)
--1, OpenRowset
--query Example
SELECT * FROM OPENROWSET (' SQLOLEDB ', ' SQL Server name '); ' User name '; ' Password ', database name. dbo. Table name)
--Raw cost surface
SELECT * Into table from OPENROWSET (' SQLOLEDB ', ' SQL Server name '); ' User name '; ' Password ', database name. dbo. Table name)
--Import a local table into a remote table
Insert OPENROWSET (' SQLOLEDB ', ' SQL Server name '); ' User name '; ' Password ', database name. dbo. Table name)
Select *from Local surface
--Update the local surface
Update b
Set B. Column a=a. Column A
From OPENROWSET (' SQLOLEDB ', ' SQL Server name '); ' User name '; ' Password ', database name. dbo. Table name) as a inner join local table B
On A.column1=b.column1
--openquery usage requires creating a connection
--First create a connection create a linked server
exec sp_addlinkedserver ' itsv ', ', ' SQLOLEDB ', ' Remote server name or IP address '
--Query
SELECT *
From OPENQUERY (ITSV, ' SELECT * from database. dbo. Table name ')
--Import a local table into a remote table
Insert OpenQuery (ITSV, ' SELECT * from database. dbo. Table name ')
SELECT * FROM local surface
--Update the local surface
Update b
Set B. column b=a. Column B
From OPENQUERY (ITSV, ' SELECT * from database. dbo. Table name ') as a
Inner JOIN local table B on a. Column a=b. Column A
--3, Opendatasource/openrowset
SELECT *
From OpenDataSource (' SQLOLEDB ', ' Data source=ip/servername; User id= login name; password= password '). Test.dbo.roy_ta
--Import a local table into a remote table
Insert OpenDataSource (' SQLOLEDB ', ' Data source=ip/servername; User id= login name; password= password '). database. dbo. Table name
SELECT * FROM