Compare two tables and Update

• sean.kehinde

  SSC Veteran

  Points: 262

  More actions

  April 11, 2010 at 11:00 pm

  #220375

  I currently have a table that is copied from an Oracle database table into SQL. Assuming that table A is my Oracle table and table B is the SQL server copy of table A.

  Lets say that I created a tempA table is SQL from Oracle.

  I am trying to find out if records in table B are the same as my tempA table and also update table B with the difference.

  Is this possible? And if it is anyone got an idea on how to go about it?

• Pulivarthi Sasidhar

  SSCertifiable

  Points: 6706

  More actions

  April 11, 2010 at 11:27 pm

  #1149814

  hi,

  Could you please give full Info.....

  Take the data of TableA [Oracle] into excel....and import the data into SQL DB..

  or

  if the both tables have record ids.....then update the each column using following...

  UPDATE TABLEB SET B.col1=A.col1 ,.....

  FROM TableB B inner join TableA A on B.id=A.id

  This statement will update the matched columns from TableA ....

  Insert the rows which are not existed in table B...

  Thanks!

  Sasidhar P 🙂