дһ¸öSQLÓï¾ä¡£ - MS-SQL Server / Ó¦ÓÃʵÀý

±í£ºT1Êý¾ÝÈçÏÂ

a 1
a 2
a 3
b 1
b 2

±í t2Êý¾ÝÈçÏÂ
a 1
a 2
a 3
a 4
b 1
b 2
b 3

Ïë´Ót2Öеóö
a 4
b 3
µÄSQLÓï¾ä¡£

---

select * from tb2
intersect 
select * from tb1

---

SQL code:
select * from tb2
except
select * from tb1

---

SELECT * from TB2 T WHERE NOT EXISTS(SELECT 1 from TB1 WHERE A=T.A AND B=T.B)

---

---

SQL code:
--------------------SQL ServerÊý¾Ý¸ñʽ»¯¹¤¾ß-------------------
---------------------------------------------------------------
-- DESIGNER :happycell188(ϲϲ)
-- QQ :584738179
-- Development Tool :Microsoft Visual C++ 6.0 C Language
-- FUNCTION :CONVERT DATA TO T-SQL
---------------------------------------------------------------
-- Microsoft SQL Server 2005
-- Developer Edition on Microsoft Windows XP [°æ±¾ 5.1.2600]
---------------------------------------------------------------
---------------------------------------------------------------

use test
go
if object_id('test.dbo.t1') is not null drop table t1
-- ´´½¨Êý¾Ý±í
create table t1
(
id char(2),
num int
)
go
--²åÈë²âÊÔÊý¾Ý
insert into t1 select 'a',1
union all select 'a',2