BEGIN TRAN declare @error int insert into tableA set @error = @@error if @error <>0 begin print '插入失败' rollback tran end //得到刚插入记录的id declare @id int set @id = @@identity insert into tableB set @error = @@error if @error<>0 begin print '插入失败' rollback tran end commit tran
declare @error int
insert into tableA
set @error = @@error
if @error <>0
begin
print '插入失败'
rollback tran
end
//得到刚插入记录的id
declare @id int
set @id = @@identity
insert into tableB
set @error = @@error
if @error<>0
begin
print '插入失败'
rollback tran
end
commit tran