用导出、导入向导:select * from SEVER2 where ID not in(select ID from 数据库名.dbo.SERVER2)
1:使用鏈接服务器 EXEC sp_addlinkedserver 'Test', --名称 '', 'MSDASQL', NULL, NULL, 'DRIVER={SQL Server};SERVER=服务器名;UID=sa;PWD=密码;' GO -------以上为添加连接服务器exec sp_addlinkedsrvlogin 'test','false','sa','sa','' select * from Test.库名.dbo.表名 2.使用OPENROWSET方式: SELECT a.* FROM OPENROWSET('MSDASQL', 'DRIVER={SQL Server};SERVER=serve;UID=sa;PWD=sa', db.dbo.table) AS aSELECT * FROM OPENQUERY(TEST, 'SELECT name, id FROM db.table') set XACT_ABORT on SET ANSI_NULL_DFLT_ON on
插入語句加上 not in 即可。
用导出、导入向导:select * from SEVER2 where ID not in(select ID from 数据库名.dbo.SERVER1) 上面写成SERVER2了
EXEC sp_addlinkedserver
'Test', --名称
'',
'MSDASQL',
NULL,
NULL,
'DRIVER={SQL Server};SERVER=服务器名;UID=sa;PWD=密码;'
GO
-------以上为添加连接服务器exec sp_addlinkedsrvlogin 'test','false','sa','sa',''
select * from Test.库名.dbo.表名 2.使用OPENROWSET方式:
SELECT a.*
FROM OPENROWSET('MSDASQL',
'DRIVER={SQL Server};SERVER=serve;UID=sa;PWD=sa',
db.dbo.table) AS aSELECT *
FROM OPENQUERY(TEST, 'SELECT name, id FROM db.table')
set XACT_ABORT on
SET ANSI_NULL_DFLT_ON on
上面写成SERVER2了