在这种情况下如何使用T-SQL MERGE? [英] How to use T-SQL MERGE in this case?
本文介绍了在这种情况下如何使用T-SQL MERGE?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我是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屋!
查看全文