Upsert

An Upsert (a contraction of Update and Insert) call can create new records and update existing records using one API call.  Upsert creates a new record if the record does not exist or, if the record already exists, updates the existing record.

In SQL Server, the equivalent is MERGE.

Release Introduced Online: