Update if Exist Else Insert if not exists

• rjbautista20

  Grasshopper

  Points: 13

  More actions

  March 3, 2014 at 8:07 pm

  #284183

  Good day to all the gurus in this forum,

  I'm really new in sql programming and have some difficulty generating what i want.

  i would like to know how to update an existing rows and specific column if exist but if not exist i need to insert that rows.

  would like to have your ideas...

• SQLCJ

  SSCommitted

  Points: 1791

  More actions

  March 4, 2014 at 12:02 am

  #1693755

  If I understood your question correctly then MERGE statement should solve your problem. Please take a look at http://msdn.microsoft.com/en-us/library/bb510625.aspx