开发者

In Firebird would be a way to auto-update coincident rows in a INSERT procedure?

开发者 https://www.devze.com 2023-01-17 18:31 出处:网络
if you are running a query that inserts a new set of records in a table from other one, t开发者_开发技巧here is a way to force the update of the coincident pk record in the destination table, without

if you are running a query that inserts a new set of records in a table from other one, t开发者_开发技巧here is a way to force the update of the coincident pk record in the destination table, without deleting records or split the process in two others (insert new and update existing)?


In Firebird 2.1, you can do Update or Insert

UPDATE OR INSERT INTO T1 (F1, F2)
    VALUES (:F1, :F2)
    MATCHING (F1);
0

精彩评论

暂无评论...
验证码 换一张
取 消