Does it rollback all the transactions if error occurs while using Transaction usig C# in ASP.Net

Last Reply on Jul 20, 2016 03:27 AM By Shashikant

Posted on Jul 20, 2016 02:42 AM

Hello I have a question in SQL Transaction and Stored Proc with several commands.

My question is I have One SQL Transaction and Two Stored Proc with several commands.

Inside 2 Stored Proc

Insert ...
Insert ...
Update ...

what if one of the stored proc failed to insert or update

do you think it will ROLLBACK?

You are viewing reply posted by: Shashikant on Jul 20, 2016 03:27 AM.
Posted on Jul 20, 2016 03:27 AM

It will ROLLBACK.