create trigger test on tb for insert as declare @num int select @num=count(*)from tbdelete from inserted where @num>shulaing
declare @i int select @i=count(*) from 表 if(@i=50) begin delete from 表 where 关键字 =(select 关键字 from inserted) end
create trigger test on tb for insert as declare @num int select @num=count(*)from tb select @num= @num+count(*) from inserted delete from inserted where @num>shulaing漏了一点哈哈
这个没有必要,在触发器上加top 就可以了create trigger test on tb for insert as insert into tb select top 100 * from inserted
create trigger no_10_row on test for insert as declare @row int select @row=count(*) from test if @row>10 rollback go
create trigger test on tb instead of insert as declare @num int select @num=count(*)from tb if(@num<4) begin insert tb(aid,b_rq,rq) select aid,b_rq,rq from inserted -- end
create trigger test on tb for insert
as
declare @num int select @num=count(*)from tbdelete from inserted where @num>shulaing
declare @i int
select @i=count(*) from 表
if(@i=50)
begin
delete from 表 where 关键字 =(select 关键字 from inserted)
end
as
declare @num int select @num=count(*)from tb
select @num= @num+count(*) from inserted delete from inserted where @num>shulaing漏了一点哈哈
这个没有必要,在触发器上加top 就可以了create trigger test on tb for insert
as
insert into tb
select top 100 * from inserted
create trigger no_10_row on test for insert
as
declare @row int
select @row=count(*) from test
if @row>10 rollback
go
instead of insert
as
declare @num int
select @num=count(*)from tb
if(@num<4)
begin
insert tb(aid,b_rq,rq) select aid,b_rq,rq from inserted --
end