FOR 和 AFTER 触发器之间的区别? [英] Difference between FOR and AFTER triggers?

问题描述

FOR 和 AFTER 触发器有什么区别?

What's the difference between FOR and AFTER triggers?

推荐答案

没有区别，他们做同样的事情.

There is no difference, they do the same thing.

CREATE TRIGGER trgTable on dbo.Table FOR INSERT,UPDATE,DELETE

与

CREATE TRIGGER trgTable on dbo.Table AFTER INSERT,UPDATE,DELETE

INSTEAD OF 触发器是不同的，它在插入之前而不是插入之前触发，并且可以在视图上使用，以便将适当的值插入到基础表中.

An INSTEAD OF trigger is different, and fires before and instead of the insert and can be used on views, in order to insert the appropriate values into the underlying tables.

这篇关于FOR 和 AFTER 触发器之间的区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！