title: Updating using multiple query vs case recommendation
body: <p>I was looking around updating using multiple queries vs using case when I came across this answer.
  <a href="https://stackoverflow.com/questions/6446250/sql-statement-with-multiple-sets-and-wheres">SQL Statement with multiple SETs and WHEREs</a></p>
  
  <p>and I came across this answer which said is NOT recommended.</p>
  
  <pre><code>UPDATE  table
  SET ID = CASE WHEN ID = 2555 THEN 111111259 
              WHEN ID =2724 THEN 111111261
              WHEN ID = 2021 THEN 111111263
              WHEN ID = 2017 THEN 111111264
            END
  WHERE ID IN (2555,2724,2021,2017)
  </code></pre>
  
  <p>Why is this not recommended? Isn't it better since you are only going through the table once instead of multiple times with multiple queries. Especially in a large table?</p>