title: Getting updated columns from table excluding few columns updates in SQL Server
body: <p>Help on this scenario to get desired result set.</p>
  
  <p>A table contains 10 columns among them 3 columns are count field,'updated date' &amp; 'Created Date'. This table have values updated or created using a SP in that SP, we will compare the input table and output table entire row if matches then we will update the updated date to the run date and increment count field. If not matches then we will insert into a new column in the output table. </p>
  
  <p>My requirement is I need know how many rows got updated irrespective to two fields in that table. eg. Table having first name, last name , phone no and fax no and emp id. I need to know count of rows updated irrespective to phone no and fax no.</p>
  
  <p>Thanks in advance.</p>