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#.
See Question&Answers more detail:os