能举个例子吗:我有两个数据库,结构一样的,就是数据不一样,我想在第3个数据库建立对这两个数据库的连接视图,如何做??

[哈哈007哈]

同上

[WangZWang]

如
create view vw_temp
as
select * from 库1..表1 as a inner join
库2..表3 as b on a.col1=b.col1

[xingfuniao]

create view vmT
select *
from D1..T1
union
select *
from T2

[davorsuker39]

create view vw_temp
as
select * from 库1..表1 as a inner join
库2..表3 as b on a.col1=b.col1

同意

[哈哈007哈]

xiexie

[哈哈007哈]

如果我的2个库和视图分别位于3个数据库服务器上,那该如何写呢

[dxai]

用opendatasource试一试:
Create view my_view
as

SELECT *
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=ServerName1;User ID=MyUID;Password=MyPass'
).yourdb.dbo.t1
union
SELECT *
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=ServerName2;User ID=MyUID;Password=MyPass'
).yourdb.dbo.t2

[哈哈007哈]

好象不行呀

[哈哈007哈]

我知道了,谢谢