1. Triggers are implicitly called by DB itself while SP has to be manually called by user.
2. SP can pass the parameters which is not a case with Triggers.
3. While creating a Trigger, triggering event n action has to be specified, which isn’t a case with SP.
4. A Trigger can call the specific SP in it but the reverse is not true.
Differences between Trigger and Stored Procedure
本文探讨了数据库中触发器与存储过程的主要不同之处:触发器由数据库自身隐式调用,而存储过程需用户手动调用;存储过程可以传递参数,触发器则不行;创建触发器时需指定触发事件及动作,而存储过程无需此步骤;触发器可调用特定存储过程,反之则不成立。


被折叠的 条评论
为什么被折叠?



