开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜