Executed Nested Stored Procedure

See more:

VB

stored-procedure

Hi Frnds,

I hav a doubt whether we can execute a nested stored procedures.. I.e. in our single page we have multiple insert,delete,update commands.. we like to convert it to stored procedure also we are using transactions.. if no error occurs transaction commit otherwise it will rollback all commands... now what my question is how to execute all DML commands in a single sp.. MY idea is to Create a one sp inside that use try catch block and transaction... Inside BEGIN Try execute a another stored procedure... if error occurs rollback a nested stored procedure commands also.. it will work or not... Any suggestions pls welcome....