Method 1:
Copy codeThe Code is as follows:
/* Create a linked server */
Exec sp_add0000server 'srv _ lnk ', '', 'sqloledb', 'IP address of the bar code database'
Exec sp_add1_srvlogin 'srv _ lnk ', 'false', null, 'username', 'Password'
Go
/* Query example */
Select a. ListCode
FROM srv_lnk. Name of the barcode database. dbo. ME_ListCode A, IM_BarLend B
Where a. ListCode = B. ListCode
Go
/* Delete the linked server */
Exec sp_dropserver 'srv _ lnk ', 'droplogins'
Method 2:
Copy codeThe Code is as follows:
Exec sp_configure 'show advanced options', 1
Reconfigure
Exec sp_configure 'ad Hoc Distributed Queries ', 1
Reconfigure
Go
Select * from Product p inner join
Opendatasource ('sqloledb', 'Data Source = Macaco-Online; user ID = sa; password = sa password; '). Company. dbo. Product p2
On P. PID = p2.PID
Go
Exec sp_configure 'ad Hoc Distributed Queries ', 0
Reconfigure
Exec sp_configure 'show advanced options', 0
Reconfigure
Go