sql server 跨库查询

方法一：
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

---