title: TSQL Merge error handling
body: <p>Need help handling  errors while running a merge statement.
  How do I make the merge behave as if it has  a try-catch block surrounding each row processed
  ( If an error is encountered, catch that error and log it (or any other processing)  then continue processing the next rows)?
  What is the default behavior of the Merge statement, does it rollback the whole transaction when an error occurs or it continues processing the records?
  Can the  output clause be used to check for errors?</p>