http://blog.sina.com.cn/s/blog_6dff14bc01012lw9.html
Exec sp_droplinkedsrvloginDBVIP,Null
Exec sp_dropserverDBVIP
EXEC
EXEC sp_addlinkedsrvlogin
Select
/ORACLE
Exec sp_droplinkedsrvlogin demo,Null
Exec sp_dropserver demo
go
EXEC sp_addlinkedserver
EXEC sp_addlinkedsrvlogin
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')
S ('hello');
DELETE OPENQUERY (demo, 'SELECT id FROM tbdemo WHERE name =''hello''');
[转]http://limindo.blog.163.com/blog/static/2647585620108265454371/