Cook Children's Health Care System Interview Question
How would you insert new records into a table, and update existing data if the record had changed?
Interview Answer
Anonymous
Feb 20, 2024
This is an "upsert" operation. Essentially, use a primary key for the record and check if it exists in the target table. Insert the record if it doesn't exist. If the record does exist then update data in the target table.