在这种情况下如何使用 T-SQL MERGE? [英] How to use T-SQL MERGE in this case?

问题描述

我是 T-SQL 命令 MERGE 的新手，所以我在我的 SQL 逻辑中找到了一个可以使用它的地方并想测试它，但不知道我应该如何使用它:

I'm new to T-SQL command MERGE so I found a place in my SQL logic where I can use it and want to test it but can't figure out how exactly should I use it:

IF (EXISTS (SELECT 1 FROM commissions_history WHERE request = @requestID))
    UPDATE commissions_history
    SET amount = @amount
    WHERE request = @requestID
ELSE
    INSERT INTO commissions_history (amount) VALUES @amount)

请建议正确的用法.谢谢！

Please suggest the proper usage. Thanks!

推荐答案

你看帮助了吗?这是一个简单的例子:

Did you look in the help? Here's a simple example:

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

这篇关于在这种情况下如何使用 T-SQL MERGE?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！