Posts by Renan • 101 points

• 10

  votes

  2

  answers

  413

  views

  Q: Update with Case When you need Where?

  UPDATE bethadba.FOFILHOS SET CPF = CASE WHEN CODI_EMP = 61 AND I_EMPREGADOS = 156 AND i_filhos = 1 THEN '00551366133' WHEN CODI_EMP = 57 AND I_EMPREGADOS = 290 AND i_filhos = 1 THEN '00636170993'…

  sql sql-update case

  asked 6 years, 5 months ago Renan 101