--sqlserver creating a linked server
--
--1, the Oracle interface attribute selection in the Access interface allows in-process
--
--Delete linked server
EXEC master.dbo.sp_dropserver @server =n ' orcl_server ', @droplogins = ' droplogins '
--Add a linked server
EXEC master.dbo.sp_addlinkedserver @server = N ' Orcl_server ', @srvproduct =n ' Oracle ', @provider =n ' oraoledb.oracle ', @ Datasrc=n ' ORCL '
--Add Linked server login
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname =n ' orcl_server ', @useself =n ' False ', @rmtuser =n ' orcl_username ', @ Rmtpassword= ' * * * *
--The query statement format is:
Select * from Orcl_server. Orcl_username. Oracle table name (mandatory capitalization)
SELECT * FROM OPENQUERY (orcl_server, ' SELECT * from T_user ')
--The INSERT statement format is:
Insert into Orcl_server. Cdc_weibinqu. Oracle table name (mandatory capitalization)
Select * FROM table name
SQL Server creates linked servers