MERGEコマンドで挿入、更新、削除を自動的に完了

475 ワード

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 
;