Link to home
Start Free TrialLog in
Avatar of Dazza051197
Dazza051197

asked on

updating a table with values from another table

Can someone provide me with the sql which will update the records in table 1 with the records from table2 that are different, but columns 'ID' are equal in both tables.  and also append any records from table2 that arent in table1.

I know the easiest way would be to delete from table1 then insert into table1 (select * from table2), but I don't want to enable the select into option on the database because it doesn't use the transaction log.

Daz
ASKER CERTIFIED SOLUTION
Avatar of simonsabin
simonsabin

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Dazza051197
Dazza051197

ASKER

Thanks.