第1个回答 2012-01-04
简单点直接两条insert语句就行了啊
比如,
insert into a(name) values ('judy')
go
insert into b(name) values ('judy')
复杂点把这写语句放在事务里面执行
begin transaction
declare @errorSum int
set @errorSum=0
insert into a(name) values ('ane')
set @errorSum=@errorSum+@@error
insert into b(name) values ('ane')
set @errorSum=@errorSum+@@error
if @errorSum <>0
rollback transaction
else
commit transaction本回答被网友采纳