创建了40个插入触发器 执行insert into 命令也就一闪而过,并未感觉变慢 create table tmp (id int) go create trigger trigI_tmp1 on tmp for insert as declare @id int set @id=1 gocreate trigger trigI_tmp2 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp3 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp4 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp5 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp6 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp7 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp8 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp9 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp10 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp11 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp12 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp13 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp14 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp15 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp16 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp17 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp18 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp19 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp20 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp21 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp22 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp23 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp24 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp25 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp26 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp27 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp28 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp29 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp30 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp31 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp32 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp33 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp34 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp35 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp36 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp37 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp38 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp39 on tmp for insert as declare @id int set @id=1 go create trigger trigI_tmp40 on tmp for insert as declare @id int set @id=1 go
执行insert into 命令也就一闪而过,并未感觉变慢
create table tmp (id int)
go
create trigger trigI_tmp1 on tmp
for insert
as
declare @id int
set @id=1
gocreate trigger trigI_tmp2 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp3 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp4 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp5 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp6 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp7 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp8 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp9 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp10 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp11 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp12 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp13 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp14 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp15 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp16 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp17 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp18 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp19 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp20 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp21 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp22 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp23 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp24 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp25 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp26 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp27 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp28 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp29 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp30 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp31 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp32 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp33 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp34 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp35 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp36 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp37 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp38 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp39 on tmp
for insert
as
declare @id int
set @id=1
go
create trigger trigI_tmp40 on tmp
for insert
as
declare @id int
set @id=1
go