title: How to Update Two tables with single statement in sql server?
body: <p>I have two tables and I want to update both the tables with single Query</p>
  
  <p>Sample query:</p>
  
  <pre><code>UPDATE T1, T2 SET T1.FirstName = T2.SecondName ,T2.SecondName = T1.FirstName
  FROM Table1 T1, Table2 T2
  WHERE T1.id = T2.id
  </code></pre>
  
  <p>Is there any mechanism for doing this in the Sql server</p>