Import data from a remote database to a local database __ database

--Create a linked server
exec sp_addlinkedserver ' srv_lnk ', ', ' SQLOLEDB ', ' Remote server name or IP address '
exec sp_addlinkedsrvlogin ' Srv_lnk ', ' false ', NULL, ' username ', ' password '
Go

--query Example
SELECT * from Srv_lnk. Database name. dbo. Table name

--Import sample
SELECT * into table from Srv_lnk. Database name. dbo. Table name

--Delete a linked server when you no longer use it
exec sp_dropserver ' srv_lnk ', ' droplogins '
Go

--If only for temporary access, you can use OPENROWSET directly
--query Example
SELECT * FROM OPENROWSET (' SQLOLEDB '
, ' SQL Server name '; User name '; ' Password
, database name. dbo. Table name)

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