title: Multiple SET expressions in query?
body: <p>Want to update specific data in a Table Column.</p>
  
  <p>I can use the below for one entry:</p>
  
  <p><code>UPDATE [BULDING].[dbo].[TB_<em>DATA]<br/>
  SET OFFICE</em>_ID = '4' where OFFICE__ID = '8';</code></p>
  
  <p>But what should I use for multiple entry change - below obviously does not work:</p>
  
  <p><code>UPDATE [BULDING].[dbo].[TB_<em>DATA]<br/>
  SET OFFICE</em>_ID = '4' where OFFICE_<em>ID = '8'<br/>
  SET OFFICE</em>_ID = '4' where OFFICE_<em>ID = '10'<br/>
  SET OFFICE</em>_ID = '11' where OFFICE__ID = '3';</code></p>
  
  <p>Thanks!</p>