sqlserver2008如何实现 跨数据库 复制，查询？ 跨数据库查询用 jpa 怎么实现？ 求高手赐教？

opendatasource('sqloledb,'Data Source=服务器地址;UserID=sa;Password=pass@word1 ')数据库名字dbo[表名] 这是跨服务器的调用，如不是不是跨服务器，直接数据库名dbo表名

方法一：
select from servernamedbotablename
方法二：
select from OPENDATASOURCE(
'SQLOLEDB',
'Data Source=远程ip;User ID=sa;Password=密码'
)库名dbo表名
where 条件
select top 100 from OPENDATASOURCE(
'SQLOLEDB',
'Data Source=1921686100;User ID=sa;Password=1234'
)[zhaolx-test]dboTGongwen
where gid <5
insert into OPENDATASOURCE(
'SQLOLEDB',
'Data Source=1921686100;User ID=sa;Password=1234'
)[zhaolx-test]dbot_aaa (id ,name )values('001','Tom')
select top 100 from OPENDATASOURCE(
'SQLOLEDB',
'Data Source=1921686100;User ID=sa;Password=1234'
)[zhaolx-test]dbot_aaa

Select TA From Adboproducts TA
join Bdboprice TB
On TAP_Pid = TBPid
Order By TBPri

---