You can accomplish this behaviour using savepoints. Begin the transaction in the outer batch. In the procedure, do not create a new transaction, create a savepoint using the...

In a common development environment, the available stored procedures and functions are the only things available to the application developers to Select, Insert, Update, and Delete data. It is...