且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在SQL表中同时更新现有记录并插入新记录? SQL

更新时间:2023-11-30 20:58:16

也许是可以用作UPSERT命令的MERGE命令是你需要的。

参见这篇文章:使用MERGE语句执行UPSERT& mdash; DatabaseJournal.com [ ^ ]
Maybe the MERGE command which can be used as "UPSERT" command is what you need.
See this article: Using the MERGE Statement to Perform an UPSERT — DatabaseJournal.com[^]