是否可以在sql服务器“之前"中执行触发器?执行插入语句? [英] Is it possible to execute a trigger in sql server "BEFORE" executing an insert statement?

问题描述

尊敬的先生/女士，

我想在sql sever 2005中的INSERT/UPDATE语句之前调用触发器.在INSERT或UPDATE之后，我能够使用"AFTER"关键字来触发事件，但无法调用BEFORE.请帮帮我.

Dear sir/Madam,

I would like to invoke a trigger on BEFORE the INSERT/UPDATE statement in sql sever 2005. I am able to use the ''AFTER'' key word for triggering an event after INSERT OR UPDATE but unable to invoke BEFORE. Kindly help me out.

推荐答案

http://www.roseindia.net/sql/create-before-insert-trigger.shtml [

http://www.roseindia.net/sql/create-before-insert-trigger.shtml[^]

Check this link :)

这篇关于是否可以在sql服务器“之前"中执行触发器?执行插入语句?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！