CREATE TRIGGER yourname ON goods
instead of INSERT
AS
if (select count(*) from goods)<30
begin
insert into goods select * from inserted
end
instead of INSERT
AS
if (select count(*) from goods)<30
begin
insert into goods select * from inserted
end
FOR INSERT
AS
if (select sum(1) from goods)>50
rollback tran
FOR INSERT
AS
if (select sum(1) from goods)>50
rollback tran
FOR INSERT
AS
if (select sum(1) from goods)>50
rollback tran
FOR INSERT
AS
if (select sum(1) from goods)>30
rollback tran
for insert
as
if(select count(*) from 表名)>30 rollback tran
for insert
as
if(select count(*) from aa)>30
delete aa where ...最前面那条记录的条件
on aa
for insert
as
if ((select sum(1) from aa) > 11 )
delete aa where 主健 =(select top 1 主健 from aa)
for insert
as
if(select count(*) from 表名)>30 rollback tran
for insert
as
begin
if(select count(*) from 表名)>30
delete from 表名 where 刪除的條件
end