create trigger aaa on tablename
instead of insert
as begin
declare @mycount int
select @mycount=count(*) from tablename where id=@kkk
if @mycount<5 begin
insert into tablename select * from inserted
end
instead of insert
as begin
declare @mycount int
select @mycount=count(*) from tablename where id=@kkk
if @mycount<5 begin
insert into tablename select * from inserted
end
create trigger aaa on tablename
instead of insert
as begin
declare @mycount int
select @mycount=count(*) from tablename where id= (select top 1 id from inserted)
if @mycount<5 begin
insert into tablename select * from inserted
end
谢谢!
FOR INSERT, UPDATE
as
begin
declare @mycount int
select @mycount=count(*) from Certificates where UserID= (select top 1 UserID from inserted)
if @mycount>5
begin
raiserror('Too many',16,1)
rollback
end
end