title: What controls the order of INSERT, UPDATE and DELETE operations in a SQL MERGE statement?
body: <p>How does SQL Server's <code>MERGE</code> work?</p>
  
  <p>If there are multiple operations to be performed (<code>INSERT</code>,<code>UPDATE</code>,<code>DELETE</code>) then what controls the order in which these operations are carried out?</p>