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
;