Executing a stored procedure inside BEGIN/END TRANSACTION
Yes, everything that you do between the Begin Transaction and Commit (or Rollback) is part of the transaction.
Yes, everything that you do between the Begin Transaction and Commit (or Rollback) is part of the transaction.
A using statement should be used every time you create an instance of a class that implements IDisposable within the scope of a block. It ensures that the Dispose() method will be called on that instance, whether or not an exception is thrown. In particular, your code only catches managed exceptions, then destroys the stack … Read more