Howdy. Would love to see an option in SQL Server that updates existing records or inserts a new record in the case that the record doesn't exist. I have seen names such as 'Upsert' or 'Update or Insert' in the past.
I think the Transact-SQL term is Merge (although Microsoft does use the term upsert in other contexts)
Very much needed!