You may have heard the UPSERT functionality in sql statements. In short an upsert statements UPDATEs records if they are existing in the table or in the selected row set else INSERTs records to the table as new rows within a single sql command.
You
Read More