title: sql stored procedure to compare two tables and return the columns in which data is different
body: <p>Need help with sql sp. I will be calling this sp from vbscript with two table names</p>
  
  <pre><code>table1
  id  f-name l_name phone
  1   john   smith  111-111-1111
  2   john   doe    222-222-2222
  3   peter  Wu     333-333-3333
  4   peter  Wang   444-444-4444
  table2
  id  f-name l_name phone
  1   john   smith  123-456-1111
  2   john   doe    234-222-2222
  3   peter  Wu     345-454-3333
  4   peter  Wang   456-444-4444
  </code></pre>
  
  <p>the stored procedure, first should get top 1 * from both the tables and should compare the first row from table1 and table2 and return all the column names if the data is not same, here the stored procedure should return column "phone".
  I am naive in sql and need help to write this stored procedure.</p>