Last post Jan 24, 2019 04:42 AM by yrb.yogi
Jan 24, 2019 03:49 AM|robby32|LINK
I have a table that has some data in it and a number of columns.
I create a new table by doing
"insert into table1 select * from table1Temp";
I hold the data in tab;le1temp and then insert into tab;le1.
if I populate table1temp with more data, I want to insert into table1 else update existing record
Jan 24, 2019 04:42 AM|yrb.yogi|LINK
You can use the SQL MERGE Command to do the insert/update.
Find the details