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?