sql MERGE

1--WHEN  NOT MATCHED  BY Source 和WHEN  NOT MATCHED  BY TARGET 是固定格式
2--用USING中查到的数据S 对T表来操作
3 MERGE INTO [Admin] T  
4                USING Admin2 AS S  
5                ON ( T.LoginId = S.LoId ) 
6                WHEN  NOT MATCHED  BY TARGET THEN  --目标表(T)中不存在  源表(S)中存在  
7                INSERT (LoginId ,LoginPwd )
8                VALUES (s.loid ,s.lopwd);
9go
10 MERGE INTO [Admin] T  
11                USING Admin2 AS S
12                ON ( T.LoginId = S.LoId ) 
13                WHEN  NOT MATCHED  THEN  --目标表(T)中不存在  源表(S)中存在   
14                INSERT (LoginId ,LoginPwd )
15                VALUES (s.loid ,s.lopwd);
16go
17 MERGE INTO [Admin] T   
18                USING Admin2 AS S
19                ON ( T.LoginId = S.LoId ) 
20                WHEN  NOT MATCHED  BY Source THEN  --目标表(T)中存在  源表(S)中不存在
21                delete;
22go

 WHEN MATCHED 是当上面条件成立 执行下面操作

WHEN MATCHED 后面可以跟 and

WHEN  NOT MATCHED  BY Source 和 WHEN  NOT MATCHED  BY TARGET 是固定格式

WHEN  NOT MATCHED  BY TARGET 和  WHEN  NOT MATCHED 相同

用Using中查到的数据S 对 T操作