如果是插入到TEST3中就可以这么做.
CREATE TRIGGER tr_test1_up
ON TEST1
FOR INSERT, UPDATE,DELETE
AS
Insert into TEST3
select top 5 * from TEST1 where AA not in
(select DD from TEST2) order by cc DESC
GO
CREATE TRIGGER tr_test1_up
ON TEST1
FOR INSERT, UPDATE,DELETE
AS
Insert into TEST3
select top 5 * from TEST1 where AA not in
(select DD from TEST2) order by cc DESC
GO
for insert,update
as
begin
--存在更新
update test3 set gg=b.bb,hh=a.cc
from inserted a,test3 b
where a.aa not in (select dd from test2) and a.aa=b.ff
and datediff(day,cc,getdate())<=5
--不存在插入
insert test3 select * from inserted where aa not in (select ff from test3)
end