?????????????????????????

??????????????????????????????????????????о???????????????μ???????????????
???????????????B??C??????????A???????
createViewView_User_B
as
(
select
*
fromopendatasource
(
'SQLOLEDB'??
'DataSource=192.168.1.136;UserID=sa;Password=000'
).UserB.dbo.UserTBast1
)astt1
)
createViewView_User_C
as
(
select
*
fromopendatasource
(
'SQLOLEDB'??
'DataSource=192.168.1.125;UserID=sa;Password=123'
).UserC.dbo.User_TCast1
)
?????????????????????
????select*fromdbo.View_User_Bast1joinView_User_Cast2ont1.UserID=t2.UserID
??????????????????????????????????????