USE master go EXEC sp_addlinkedserver @server='YourOracleSERVER', @srvproduct='Oracle', @provider='MSDAORA', @datasrc='YourDataSourcename', @location='', @provstr='Provider=MSDAORA.1;Data Source=YourDataSourcename;Persist Security Info=True' go EXEC sp_serveroption @server='YourOracleSERVER', @optname='rpc', @optvalue='false' go EXEC sp_serveroption @server='YourOracleSERVER', @optname='collation compatible', @optvalue='false' go EXEC sp_serveroption @server='YourOracleSERVER', @optname='data access', @optvalue='true' go EXEC sp_serveroption @server='YourOracleSERVER', @optname='rpc out', @optvalue='false' go EXEC sp_addlinkedsrvlogin @rmtsrvname='YourOracleSERVER', @useself='FALSE', @locallogin=NULL, @rmtuser='username', @rmtpassword='password' go IF EXISTS (SELECT * FROM master.dbo.sysservers WHERE srvname='YourOracleSERVER') PRINT '<<< CREATED LINKED SERVER RATESERVER >>>' ELSE PRINT '<<< FAILED CREATING LINKED SERVER RATESERVER >>>' go
EXEC sp_addlinkedserver '别名', '', 'MSDASQL', NULL, NULL, 'DRIVER={SQL Server};SERVER=远程名;UID=用户;PWD=密码;' GOinsert into b(col1,col2....) select col1,col2,col3.... from 别名...table
go
EXEC sp_addlinkedserver @server='YourOracleSERVER', @srvproduct='Oracle', @provider='MSDAORA', @datasrc='YourDataSourcename', @location='', @provstr='Provider=MSDAORA.1;Data Source=YourDataSourcename;Persist Security Info=True'
go
EXEC sp_serveroption @server='YourOracleSERVER', @optname='rpc', @optvalue='false'
go
EXEC sp_serveroption @server='YourOracleSERVER', @optname='collation compatible', @optvalue='false'
go
EXEC sp_serveroption @server='YourOracleSERVER', @optname='data access', @optvalue='true'
go
EXEC sp_serveroption @server='YourOracleSERVER', @optname='rpc out', @optvalue='false'
go
EXEC sp_addlinkedsrvlogin @rmtsrvname='YourOracleSERVER', @useself='FALSE', @locallogin=NULL, @rmtuser='username', @rmtpassword='password'
go
IF EXISTS (SELECT * FROM master.dbo.sysservers WHERE srvname='YourOracleSERVER')
PRINT '<<< CREATED LINKED SERVER RATESERVER >>>'
ELSE
PRINT '<<< FAILED CREATING LINKED SERVER RATESERVER >>>'
go
'别名',
'',
'MSDASQL',
NULL,
NULL,
'DRIVER={SQL Server};SERVER=远程名;UID=用户;PWD=密码;'
GOinsert into b(col1,col2....)
select col1,col2,col3.... from 别名...table