分布式访问方法(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"

posted @ 2007-01-30 11:38  Nick.Lee  阅读(530)  评论(0编辑  收藏  举报