title: Swap values for two rows in the same table in SQL Server
body: <p>I want to swap the values from two rows in a table. I have the rows IDs of the two rows. Is there any query to do that? Here is an example. Before the query I have this:</p>
  
  <pre>
  row1 : 1,2,3
  row2 : 5,6,7
  </pre>
  
  <p>After the swap I want this:</p>
  
  <pre>
  row1 : 5,6,7
  row2 : 1,2,3
  </pre>