SQL Server是否提供类似MySQL的ON DUPLICATE KEY UPDATE的功能 [英] Does SQL Server Offer Anything Like MySQL's ON DUPLICATE KEY UPDATE

问题描述

在MySQL中，如果您指定在重复的密钥更新上并插入一行，该行将导致UNIQUE索引或PRIMARY KEY中的值重复，对旧行执行UPDATE.例如，如果列a声明为UNIQUE并包含值1，则以下两个语句具有相同的效果:

In MySQL, if you specify ON DUPLICATE KEY UPDATE and a row is inserted that would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row is performed. For example, if column a is declared as UNIQUE and contains the value 1, the following two statements have identical effect:

INSERT INTO table (a,b,c) VALUES (1,2,3)
  ON DUPLICATE KEY UPDATE c=c+1;

UPDATE table SET c=c+1 WHERE a=1;

我不相信我曾经遇到过T-SQL之类的东西. SQL Server是否提供与MySQL的ON DUPLICATE KEY UPDATE相当的功能?

I don't believe I've come across anything of the like in T-SQL. Does SQL Server offer anything comparable to MySQL's ON DUPLICATE KEY UPDATE?

推荐答案

没有等效的DUPLICATE KEY UPDATE，但MERGE和WHEN MATCHED可能对您有用

There's no DUPLICATE KEY UPDATE equivalent, but MERGE and WHEN MATCHED might work for you

使用MERGE插入，更新和删除数据

这篇关于SQL Server是否提供类似MySQL的ON DUPLICATE KEY UPDATE的功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！