Search code examples
sqlsql-serverstored-proceduresrollbacksqltransaction

Executing a stored procedure inside BEGIN/END TRANSACTION

If I create a Stored Procedure in SQL and call it (EXEC spStoredProcedure) within the BEGIN/END TRANSACTION, does this stored procedure also fall into the transaction?

I didn't know if it worked like try/catches in C#.

Solution

  • Yes, everything that you do between the Begin Transaction and Commit (or Rollback) is part of the transaction.