如何在Triggers中传递参数？ [英] How are parameters passed in Triggers?

问题描述

大家好，

我可以知道我们如何在触发器中传递参数，如果没有参数传递，那么它们如何被触发...... ??


谢谢&问候

Nitin Sharma

Hi All,
May i know how do we pass parameters in Triggers and if no parameters are passed then how they get fired...??

Thanks & Regards
Nitin Sharma

推荐答案

触发器不需要参数。它们会自动在相关的数据库事件上执行。

trigger do not require parameters. They execute automatically on the related database events.

触发器不会指示触发器是否会触发。触发器基于您的表中发生的事件，而不是其中的参数。


- CK

Trigger does not dictate whether a trigger will fire or not. Triggers are based on events that happen to your table, not the parameters inside it.

-- CK

触发器不指示触发器是否会触发。触发器基于您的桌子上发生的事件，而不是其中的参数。


- CK

Trigger does not dictate whether a trigger will fire or not. Triggers are based on events that happen to your table, not the parameters inside it.

-- CK

当触发器被触发时我需要发送一些额外的字段。

i有一个表，当触发器触发时，该表的内容是插入到具有相同表结构的下一个表中，但是还有一个字段''modified_by''。当触发该触发器时，如何插入字段''modified_by''。 modified_by可以是应用程序登录的任何名称。

thanx

what if i need to send some extra field to be inserted when a trigger gets fired.
i have a table and when a trigger is fired, the content of that table is inserted in the next table with the same table structure but with one more field ''modified_by''. how can i insert the field ''modified_by'' when that trigger is fired. modified_by can be any name through which the application is logged in.
thanx

这篇关于如何在Triggers中传递参数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！