本文探讨了数据库中触发器与存储过程的主要不同之处：触发器由数据库自身隐式调用，而存储过程需用户手动调用；存储过程可以传递参数，触发器则不行；创建触发器时需指定触发事件及动作，而存储过程无需此步骤；触发器可调用特定存储过程，反之则不成立。
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
最新推荐文章于 2023-08-16 00:20:49 发布
扫一扫
1856
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
