怎么查询时执行触发器

如何查询时执行触发器？
我知道触发器创建有，insertd update 和deleted 增删改， 查的时候执行触发器怎么写？



CREATE trigger TrimRubbishEva
on dbo.Evaluate_Template a
after delete 
as
delete from dbo.Evaluate_Goods b where a.uuid not in (select b.template from b)
GO

这个应该怎么替换呢

------解决方案--------------------



触发器只有这三种，查询怎么还有触发器？没听过

探讨

我知道触发器创建有，insertd update 和deleted 增删改， 查的时候执行触发器怎么写？



CREATE trigger TrimRubbishEva
on dbo.Evaluate_Template a
after delete
as
delete from dbo.Evaluate_Goods b where a.uuid not in (select b……