title: How to compare all column records between two tables in SQL Server?
body: <p>I want to compare two table records. and find which one is not matching. I am not looking for which record is not found in one table</p>
  
  <p>Example: I have 2 databases called <code>DBLive</code> and <code>DBLiveBackup</code>, both with the same tables. One of the table is <code>ProductDetails</code>.</p>
  
  <p>It has 15 columns; I want to compare the <code>DBLive</code> with <code>DBLiveBackup</code> database where records are not matching.</p>
  
  <p><strong>Update</strong></p>
  
  <p><a href="https://stackoverflow.com/a/39353650/7734785">I found this link</a>. I almost looking for the same. But I cannot compare it one by one column like below code. because I have to compare whole database.</p>
  
  <pre><code>SELECT A.*, B.* 
  FROM TABLEA A
  INNER JOIN TABLEB B ON A.MSISDN = B.MSIDN
  WHERE A.firstname != B.firstname 
     OR A.lastname != B.Lastname
  </code></pre>