title: Counting the number of rows which do not match
body: <p>I have two tables with exactly the same structure i.e. same columns. I want to find out number  of rows which exist in both tables but do not have exactly the same matching values for all columns. E.g. Table has colums Id, Name, Country. Id is the primary key. If Id=1 exists in both tables then other values should also match. Currently, I am using this kind of statement.</p>
  
  <pre><code>SELECT  COUNT(*)
  FROM    ##Table1 t1 ,
          ##Table2 t2
  WHERE   t1.Id = t2.Id
          AND ( t1.Name != t2.name
                OR t1.Country != t2.Country
              )  
  </code></pre>
  
  <p>Table has too many columns hence this is becoming too unwieldly. Is there a better way to do it?</p>