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
;
用MERGE命令自动完成插入、更新和删除操作
最新推荐文章于 2022-10-13 17:41:59 发布