用MERGE命令自动完成安插、更新和删除操作

用MERGE命令自动完成插入、更新和删除操作

MERGE MyOtherContacts AS MOC  
USING  
(SELECT TOP 5 Title, Firstname, LastName FROM Person.Contact )AS C  
ON (MOC. Firstname = C. Firstname AND MOC.LastName = C. LastName)  
WHEN MATCHED THEN 
UPDATE SET MOC. Title = UPPER(C. Title)  
WHEN NOT MATCHED THEN 
INSERT (Title, Firstname, LastName)  
VALUES(C.Title, C.Firstname, C.LastName)  
WHEN NOT MATCHED BY SOURCE THEN 
DELETE 
;