TSQL Basic- Update only if existing value is NULL

• Minnesota - Viking

  Hall of Fame

  Points: 3469

  More actions

  May 20, 2011 at 10:49 am

  #236591

  In a proc with update table command , which updates 5 columns in a table ,

  how do i make only 2 columns(NewCredit) on those 5 to get updated only if the existing value of that file dis NULL.

  In short: update only if existing value is NULL

  Thanks

  [font="Verdana"]
  Today is the tomorrow you worried about yesterday:-)[/font]

• pivotlover

  SSC Enthusiast

  Points: 106

  More actions

  May 20, 2011 at 10:57 am

  #1327835

  I think you need this?

  UPDATE {TABLE}

  SET {COLUMN1}=CASE WHEN {COLUMN1} IS NULL THEN {something something}

  END

  Repeat case statement for all applicable columns

  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  The only difference between impossible and possible is time...and a little help from my friends.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  May 20, 2011 at 10:58 am

  #1327836

  UPDATE dbo.Table SET Col = CASE WHEN Col IS NULL THEN 'some new value' ELSE Col END WHERE --filter ony required rows

• Minnesota - Viking

  Hall of Fame

  Points: 3469

  More actions

  May 20, 2011 at 12:55 pm

  #1327916

  Thanks Guys

  I was'nt sure of the ELSE Case

  This answered

  

  [font="Verdana"]
  Today is the tomorrow you worried about yesterday:-)[/font]