Home Forums SQL Server 2005 T-SQL (SS2K5) How to use begin try and transaction with in a loop which call other stored procs. RE: How to use begin try and transaction with in a loop which call other stored procs.

  • March 14, 2014 at 6:08 am

    #1697107

    Few part is algorithm like loop.

    and i want to roll back only if error comes any where in side outer loop,

    and after error handeling i want continue with next id of outer loop.