分布式访问方法(OLAP)

SELECT
"a".*
FROM
OPENDATASOURCE
(
'SQLOLEDB','Data Source=ip;User ID=sa;Password=sa'
)."northwind"."dbo"."orders" "a"

SELECT
"a".*
FROM
OPENROWSET
(
'SQLOLEDB', 'DRIVER={SQL Server};SERVER=ip;UID=sa;PWD=sa', "northwind"."dbo"."orders"
) "a"

转载于:https://www.cnblogs.com/mail-ricklee/archive/2007/01/30/634423.html