在这种情况下如何使用T-SQL MERGE？

在这种情况下如何使用T-SQL MERGE？

您在帮助中了吗？这是一个简单的例子：

MERGE dbo.commissions_history AS targetUSING (SELECT @amount, @requestID) AS source (amount, request)ON (target.request = source.request)WHEN MATCHED THEN    UPDATE SET amount = source.amountWHEN NOT MATCHED THEN    INSERT (request, amount)    VALUES (source.request, source.amount);