日期:2014-05-18  浏览次数:20372 次

如何查询时执行触发器?
我知道触发器创建有,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……