27,582
社区成员




insert into tba (Aid,name) values ("101","AA")
insert into tbb (idb,price) values ("101","BB")
set xact_abort on
begin tran
insert into tba (Aid,name) values ("101","AA")
insert into tbb (idb,price) values ("101","BB")
commit tran
create table tba(aid int,name varchar(10))
go
create table tbb(idb int,price dec(18,2))
go
begin tran
insert into tba (Aid,name) values ('101','AA')
insert into tbb (idb,price) values ('101','BB')
commit;
--select * from tba
--select* from tbb
begin tran
insert into tba (Aid,name) values ('101','AA')
insert into tbb (idb,price) values ('101','12')
commit;
--select * from tba
--select* from tbb
begin tran
insert into tba (Aid,name) values ("101","AA")
insert into tbb (idb,price) values ("101","BB")
commit tran