begin tran insert into speak values(……); insert into users values(……); if @@error<>0 rollback else commit
set IDENTITY_INSERT test.dbo.speak on insert into users(uname,sex)values('rong','male') declare @a bigint select @a=@@identity insert into speak(id)values(@a)
----多写一条sql! insert into users(Id) select 1 insert into speak(Id) select 1
begin tran
insert into speak values(……);
insert into users values(……);
if @@error<>0
rollback
else
commit
set IDENTITY_INSERT test.dbo.speak on
insert into users(uname,sex)values('rong','male')
declare @a bigint
select @a=@@identity
insert into speak(id)values(@a)
----多写一条sql!
insert into users(Id) select 1
insert into speak(Id) select 1