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#.
rollbacksqlsql serversqltransactionstored-procedures
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#.
Best Answer
Yes, everything that you do between the Begin Transaction and Commit (or Rollback) is part of the transaction.