sql - Executing a stored procedure inside BEGIN/END TRANSACTION

Question

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

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

Answer 1

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