触发器 隐式事物

很简单  打印出当前连接的活动事务数

create table test1 (a int)

go

create table test2(b int)

go

create trigger tri_test

on test1

after insert

as

declare @a int

select @a=@@TRANCOUNT

insert into test2 values(@a)

GO

 

insert into test1 values(1)

go

select * from test2

 

结果：在没有任何tran的情况下  @a=1，说明是隐式事务

 

提交隐式事务

 

altertrigger tri_test

on test1

after insert

as

SET IMPLICIT_TRANSACTIONS  ON

commit

declare @a int

select @a=@@TRANCOUNT

insert into test2 values(@a)

SET IMPLICIT_TRANSACTIONS  off

GO

 

select * from test2