SQL Upsert (update or insert) pattern

Per discussed in previous article (deadlock issue), I want to list out insert or update pattern in SQL, and which pattern is more close to…