EXEC sp_addlinkedserver
@server = 'exchange',
@srvproduct = 'Oracle',
@provider = 'MSDAORA',
@datasrc = '203.17.14.23/oradbname'
exec sp_addlinkedsrvlogin 'exchange', 'false','sa', 'oracleusername, 'oraclepassword'
select * from openquery(exchange, 'select * from orausernmae.tablename')
--注意:如果不用openquery,在sqlserver本地执行会出现数据类型转换的问题,openquery是将'select * from '发送到目标数据库上进行查询,然后取得返回结果,也就是说,发送过去的语句将采用oracle的语法
exec sp_dropserver 'exchange','droplogins'