两个相关联的插入操作,该怎么处理

两个相关联的插入操作
要在两个表中插入记录，如果有一个不成功，则删除另一表中刚插入的操作。不知该如何做？
比如：

SQL code

insert into tba (Aid,name) values ("101","AA")insert into tbb (idb,price) values ("101","BB")

SQL code

begin traninsert into tba (Aid,name) values ("101","AA")insert into tbb (idb,price) values ("101","BB")commit tran
[解决办法]
SQL code
create table tba(aid int,name varchar(10))gocreate table tbb(idb int,price dec(18,2))gobegin tran  insert into tba (Aid,name) values ('101','AA')  insert into tbb (idb,price) values ('101','BB')commit;--select * from tba--select* from tbbbegin tran  insert into tba (Aid,name) values ('101','AA')  insert into tbb (idb,price) values ('101','12')commit;--select * from tba--select* from tbb
[解决办法]
SQL code
set xact_abort onbegin tran insert into tba (Aid,name) values ("101","AA") insert into tbb (idb,price) values ("101","BB")commit tran