SQL statement inserts data from the local server into the extranet server

--import data from a table in a local database into a 180 database--This is going to run exec sp_addlinkedserver on the local database.'Srv_lnk',"','SQLOLEDB','xxx.xxx.xxx'--IP exec sp_addlinkedsrvlogin of the server to be imported'Srv_lnk','false',NULL,'Account name','account Password'--account name and password of the server to be imported Go--data import INSERT into Srv_lnk.qu.dbo.AAE_InsuranceProduct (insurecompany,ccoverage,productno,productname)--Server database,SelectInsurecompany,ccoverage,productno,productname fromqu.dbo.aae_insuranceproduct--to a local database,--close connection exec sp_dropserver'Srv_lnk','droplogins' 

The connection must be closed after import, or an error will occur

SQL statement inserts data from the local server into the extranet server