Settings and activity

1 result found

1. add If not exists to data compare

   225 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   18 comments  ·  SQL Data Compare  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   AdminStephanie (Product Manager, Redgate) responded

   We've had a few requests for supporting MERGE statements - https://redgate.uservoice.com/redirect/suggestions/3100622.  Would MERGE help this or are you still looking for IF EXISTS on INSERTS?  If you'd like to chat about this, please reply.

   An error occurred while saving the comment
   Sam commented  ·  Nov 27, 2015  ·  Edit…  ·  Delete…

   Also would be nice to have the "else" statement: if exists UPDATE the row with the values described in the INSERT

   Save Submitting...
   Sam supported this idea  ·  Nov 27, 2015