asked on
SQL transaction query
I have a coded process for a SQL transaction that updates multiple tables :-
BEGIN TRANSACTION
update table 1
If succeeds
update table 2
if succeeds
COMMIT TRANSACTION
else
ROLLBACK TRANSACTION
endif
endif
On checking the data only table 2 is updated.
Please advise what I am missing.
BEGIN TRANSACTION
update table 1
If succeeds
update table 2
if succeeds
COMMIT TRANSACTION
else
ROLLBACK TRANSACTION
endif
endif
On checking the data only table 2 is updated.
Please advise what I am missing.
SQL
Last Comment
Kyle Abrahams, PMP
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Can you post your problematic script to check and confirm..