SELECT T1.* FROM T1 LEFT JOIN T2 ON T1.ID=T2.T1_ID WHERE T2.T1_ID IS NULL
IF OBJECT_ID('T1') IS NOT NULL DROP TABLE T1 GO IF OBJECT_ID('T2') IS NOT NULL DROP TABLE T2 GO CREATE TABLE T1 ( ID INT, NAME NVARCHAR(25) ) INSERT INTO T1 SELECT 1,'张三' UNION ALL SELECT 2,'李四' UNION ALL SELECT 3,'王五' UNION ALL SELECT 4,'马六'CREATE TABLE T2 ( ID INT, T1_ID INT ) INSERT INTO T2 SELECT 1,2 UNION ALL SELECT 2,3--- SELECT T1.* FROM T1 LEFT JOIN T2 ON T1.ID=T2.T1_ID WHERE T2.T1_ID IS NULL ID NAME -------- 1 张三 4 马六
FROM T1 LEFT JOIN T2 ON T1.ID=T2.T1_ID WHERE T2.T1_ID IS NULL
GO
IF OBJECT_ID('T2') IS NOT NULL DROP TABLE T2
GO
CREATE TABLE T1
(
ID INT,
NAME NVARCHAR(25)
)
INSERT INTO T1
SELECT 1,'张三' UNION ALL
SELECT 2,'李四' UNION ALL
SELECT 3,'王五' UNION ALL
SELECT 4,'马六'CREATE TABLE T2
(
ID INT,
T1_ID INT
)
INSERT INTO T2
SELECT 1,2 UNION ALL
SELECT 2,3---
SELECT T1.*
FROM T1 LEFT JOIN T2 ON T1.ID=T2.T1_ID WHERE T2.T1_ID IS NULL
ID NAME
--------
1 张三
4 马六
不同服务器的话,先建立一个连接在操作。
exec sp_addlinkedserver 'ITSV ', ' ', 'SQLOLEDB ', '远程服务器名或ip地址 '
exec sp_addlinkedsrvlogin 'ITSV ', 'false ',null, '用户名 ', '密码 ' --查询示例
select * from ITSV.数据库名.dbo.表名