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