hidrau
asked on
begin trans and roll back - doubts
Hello
I have a doubt about begin and commit and rollback.
I have a proc x and in this proc I started a begin trans, inside of my proc x, it calls a proc xy.
In the proc x I have two deletes for two tables (product, sallers) and inside of my proc xy I have one delete for my clie table.
if I call the rollback, the rollback will affect all the tables from proc x and proc xy?
thanks
Alex
I have a doubt about begin and commit and rollback.
I have a proc x and in this proc I started a begin trans, inside of my proc x, it calls a proc xy.
In the proc x I have two deletes for two tables (product, sallers) and inside of my proc xy I have one delete for my clie table.
if I call the rollback, the rollback will affect all the tables from proc x and proc xy?
thanks
Alex
Sure, but do what all good developers do: implement it on a test system and test it. Gather knowledge.. get your own findings.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks