jeudi 12 mai 2016

Update and insert to one table from another

I have two tables:

table1: (ID, Code, Name)
table2: (ID, Code, Name) with same columns

I want to to insert data from table1 to table2 or update columns if that exists in table2 (table1.ID = table2.ID)

What is the simple way to do this?

WHITOUT MERGE

Aucun commentaire:

Enregistrer un commentaire