读书人

怎么查询时执行触发器

发布时间: 2012-05-15 14:35:29 作者: rapoo

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

读书人网 >SQL Server

热点推荐