title: What are the advantages of MERGE over simple IF EXISTS?
body: <p>I want to know what are the advantages of MERGE over simply using IF EXISTS. Which is the suggested approach? Does MERGE performs Update and Insert row-by-row matching conditions? If yes, is it similar to Cursors?</p>