title: How to compare data in cells in 2 different tables in SQL Server?
body: <p>I have 2 identical tables. In one of the tables the value of the cell in any row can change, the other table is constant. How can I find out which value has changed in which row?</p>
  <p>For example, I have <code>Table1</code> (screenshot #1) which is constant and <code>Table2</code> (screenshot #2) in which value of any cell in any row can change. I want to detect the change and know what value it changed to. Number of rows and columns will remain same in both the tables.</p>
  <p>How do I compare these 2 tables as shown in the screenshots below to find out the difference?</p>
  <p><a href="https://i.stack.imgur.com/X2MhU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/X2MhU.png" alt="Image1" /></a></p>
  <p><a href="https://i.stack.imgur.com/fUFqw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fUFqw.png" alt="Image2" /></a></p>