如数据库sqlserver1中表A:
id peono datetime
001 10001 2007-10-01 10:00:00
002 10001 2007-10-02 15:00:02
003 10001 2007-10-03 16:20:00
001 10002 2007-10-05 16:00:05
002 10002 2007-10-06 19:20:23
003 10002 2007-10-10 10:10:20
......数据库sqlserver2中表B:
id peono datetime
001 10001 2007-10-01 10:00:00
003 10001 2007-10-03 16:20:00
001 10002 2007-10-05 16:00:05
003 10002 2007-10-10 10:10:20
......
通过跨库SQL语句查询出如下结果:
id peono datetime
002 10001 2007-10-02 15:00:02
002 10002 2007-10-06 19:20:23
......
SQL语句如何写,求救!
id peono datetime
001 10001 2007-10-01 10:00:00
002 10001 2007-10-02 15:00:02
003 10001 2007-10-03 16:20:00
001 10002 2007-10-05 16:00:05
002 10002 2007-10-06 19:20:23
003 10002 2007-10-10 10:10:20
......数据库sqlserver2中表B:
id peono datetime
001 10001 2007-10-01 10:00:00
003 10001 2007-10-03 16:20:00
001 10002 2007-10-05 16:00:05
003 10002 2007-10-10 10:10:20
......
通过跨库SQL语句查询出如下结果:
id peono datetime
002 10001 2007-10-02 15:00:02
002 10002 2007-10-06 19:20:23
......
SQL语句如何写,求救!
from sqlserver1..tablea
where not exists(select 1 from sqlserver2..tableb)
select * from sqlserver1.dbo.A C where not exists(select 1 from sqlserver1.dbo.B D where C.id = D.id AND C.peono = D.peono AND C.datetime = D.datetime )
--非同一數據庫時 用 openrowset 來打開另一數據庫,方法同上.
试一下,多半不得行。