我要同时执行多条sql语句如:
update table set a = 1;
update table1 set b = 1;
update table3 set c = 1;怎么样保证3条sql语句顺利执行三条语句中只要有一条没有执行成功,那么这三条应该都不执行现在写的是如果第三条未成功,这是一二条已经执行了;应该怎么样
update table set a = 1;
update table1 set b = 1;
update table3 set c = 1;怎么样保证3条sql语句顺利执行三条语句中只要有一条没有执行成功,那么这三条应该都不执行现在写的是如果第三条未成功,这是一二条已经执行了;应该怎么样
update table set a = 1;
update table1 set b = 1;
update table3 set c = 1;
commit
update table set a = 1;
update table1 set b = 1;
update table3 set c = 1;
rollback tran_namecommit
begin transaction
update [table] set a = 1;
update table1 set b = 1;
update table3 set c = 1;
rollback transaction
commit
begin transaction
update [table] set a = 1;
update table1 set b = 1;
update table3 set c = 1;
rollback transaction
commit
delete from SYS_USERS where U_ID='QQQQ';
delete from SYS_USERS where U_ID='TESTHP';
delete from SYS_KEY where code='caoyong';
commit;
exception
when others then
rollback ;
end ;