27,579
社区成员
发帖
与我相关
我的任务
分享
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