SQLSERVER 分布式查询

SELECT??? * FROM OPENDATASOURCE(
????????? 'SQLOLEDB','Data Source=192.168.0.121SQL2008;User ID=SA;Password=jonney'
????????? ).BANDO.DBO.M_Product?????????
----------------------------------------------------
??????
exec sp_addlinkedserver?? 'RMTSERVER','','SQLOLEDB','192.168.0.121SQL2008';
exec sp_addlinkedsrvlogin 'RMTSERVER','FALSE',null,'SA','SA2008';

INSERT INTO M_Product
SELECT * FROM RMTSERVER.BANDO.DBO.M_Product AS PDT
WHERE NOT EXISTS (SELECT 0 FROM M_Product WHERE PDT.PdtNo=M_Product.PdtNo)

exec sp_dropserver 'RMTSERVER','DropLogins'

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!