Intersection, _mssql2005, and difference set operations for SQL Server data sets

Their corresponding relationship can refer to the following diagram of the relevant test examples are as follows:

The relevant test examples are as follows:

Copy Code code as follows:

Use tempdb
Go
if (object_id (' T1 ') is not null) drop table T1
if (object_id (' T2 ') is not null) drop table t2
Go
CREATE TABLE T1 (a int)
INSERT INTO T1 SELECT 1 Union SELECT 2 Union Select 3
CREATE TABLE t2 (a int)
INSERT INTO T2 Select 3 Union Select 4 Union Select 5
Go
SELECT * FROM t1 union SELECT * T2
Go
/* Find table and set
1
2
3
4
5*/
SELECT * FROM t1 UNION ALL select * FROM T2
Go
/* Find table and set does not filter duplicate
1
2
3
3
4
5*/
SELECT * FROM t1 except select * FROM T2
Go
/* To find the difference set of T1 to T2
1
2*/
SELECT * FROM t1 intersect select * FROM T2
Go
/* Find the intersection of T1 to T2
3*/