title: SQL Server 2012 CHECK MY SQL QUERY BEFORE I UPDATE
body: <p>I have this update query but I do not want to run before I check what changes it will make.</p>
  
  <pre><code>UPDATE tblControls_ContractSetpointProfile
  SET CoolingOccupied = 76
  FROM tblMEP_Sites
  JOIN tblControls_ContractSetpoint ON tblControls_ContractSetpointProfile.ID = ContractSetpointID
  WHERE ProjectID in (28, 47)
  </code></pre>
  
  <p>I though I just need to replace <code>UPDATE WITH SELECT</code> but that did not work. The answer to this question does not work, please do not change anything as I see <code>SET CoolingOccupied = 76</code> is missing in the solution. I am not a database programmer but I have to do this because the person who is supposed to do this is absent. Thank you for understanding.</p>