I know the code in C# using SQL Transaction.
What I am asking is if the 2 Stored Proc have the same query of
Insert ...
Insert ...
Update ...
and when the one the stored proc failed to insert or update, do you think it will ROLLBACK?
Note: I don't need codes, I need the answer YES or NO
YES, IT WILL ROLLBACK
NO, IT WILL NOT
Which of the two is the answer?