想写一个触发器,在userinfo表里新增数据,当新增数量为10时,再把这10条数据批量插入temp表中,请问怎么实现,我写的这个实现不了
create trigger trigger_mq
on userInfo
for insert
as
if ((select count(*) as num from inserted)=10)
begin
insert into temp(name,age) select name,age from inserted
end
go
create trigger trigger_mq
on userInfo
for insert
as
begin
declare @param int
set @param=select count(*) from inserted
if (@param=10)
begin
insert into temp(name,age) select name,age from inserted
end
end
go