SQL Server Performance

Equivalent of INSERT ... ON DUPLICATE KEY UPDATE

Discussion in 'General Developer Questions' started by Rocky, Nov 2, 2006.

  1. Rocky New Member

    Hi,
    Can you please let me know if there is equivalent thing for
    INSERT ... ON DUPLICATE KEY UPDATE which is in my SQL.

  2. FrankKalis Moderator

    No, unfortunately not, AFAIK.

    --
    Frank Kalis
    Moderator
    Microsoft SQL Server MVP
    Webmaster:http://www.insidesql.de
  3. Madhivanan Moderator

    quote:Originally posted by Rocky

    Hi,
    Can you please let me know if there is equivalent thing for
    INSERT ... ON DUPLICATE KEY UPDATE which is in my SQL.


    you mean UPSERT? (insert new records and update existing)

    Madhivanan

    Failing to plan is Planning to fail
  4. FrankKalis Moderator

    http://en.wikipedia.org/wiki/Upsert

    --
    Frank Kalis
    Moderator
    Microsoft SQL Server MVP
    Webmaster:http://www.insidesql.de

Share This Page