What does the MERGE statement’s WHEN NOT MATCHED clause handle?

Question

SQL Fundamentals — Hard

What does the MERGE statement’s WHEN NOT MATCHED clause handle?

Accepted Answer

The MERGE statement's WHEN NOT MATCHED clause handles rows in the source that have no matching row in the target, typically used for INSERT operations. This clause allows new data from the source to be inserted into the target table when there is no match found.