Exec sp_droplinkedsrvlogin DBVIP,Null Exec sp_dropserver DBVIP EXEC sp_addlinkedserver @server='DBVIP',--被访问的服务器别名 @srvproduct='', @provider='SQLOLEDB', @datasrc='Server2' --要访问的服务器 EXEC sp_addlinkedsrvlogin 'DBVIP', --被访问的服务器别名 'false', NULL, 'sa', --帐号 'thankyoubobby' --密码 Select * from DBVIP.pubs.dbo.orders /ORACLE Exec sp_droplinkedsrvlogin demo,Null Exec sp_dropserver demo go EXEC sp_addlinkedserver @server ='demo', @srvproduct='Oracle', @provider='MSDAORA', @datasrc='ServiceName' EXEC sp_addlinkedsrvlogin 'demo', 'false', NULL, 'userid', 'password' go SELECT * FROM OPENQUERY(demo ,'select * from tbdemo' ) UPDATE OPENQUERY (demo, 'SELECT id FROM tbdemo WHERE id = 101') SET name = 'hello'; INSERT OPENQUERY (demo, 'SELECT id FROM tbdemo') VALUES ('hello'); DELETE OPENQUERY (demo, 'SELECT id FROM tbdemo WHERE name = ''hello''');
sp_addlinkedserver使用方法
最新推荐文章于 2023-09-01 16:04:31 发布