用这两个就行了 insert into staff(id, name) values('10011','Michael') insert into area(id, name) values('40022','北京')
begin transaction insert into staff(id, name) values('10011','Michael') if @@error<>0 begin rollback transaction return 1 end insert into area(id, name) values('40022','北京') if @@error<>0 begin rollback transaction return 1 end commit transaction return 0
insert into staff(id, name) values('10011','Michael')
insert into area(id, name) values('40022','北京')
insert into staff(id, name) values('10011','Michael')
if @@error<>0
begin
rollback transaction
return 1
end
insert into area(id, name) values('40022','北京')
if @@error<>0
begin
rollback transaction
return 1
end
commit transaction
return 0