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

zzz

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?

Shashika...

0 1

Please refer below link

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Transaction(Commit or Rollback) To Button_Click Handling Two Stored Procedure