sqlserver2012 查询远程数据库

EXEC sp_addlinkedserver 'LinkName','','SQLOLEDB','121.43.177.236'
EXEC sp_addlinkedsrvlogin 'LinkName','false',NULL,'sa','sa'

SELECT * FROM LinkName.cepone.dbo.DspSparePart

--参考
http://blog.chinaunix.net/uid-23929779-id-335932.html

转载于:https://www.cnblogs.com/kuailewangzi1212/p/6501508.html