• http://en.wikipedia.org/wiki/Merge_%28SQL%29

    "Microsoft SQL extends with supporting guards and also with supporting Left Join via WHEN NOT MATCHED BY SOURCE clauses."