In this article, we will see how to install IBM DB2 in Ubuntu step by step.
Tag: IBM DB2
What is the difference between Stored Procedure and Trigger in SQL
In this article, we will see the difference between Stored Procedure and Trigger in SQL. Following are the main differences between Stored Procedure and Trigger:
Stored Procedure | Trigger |
---|---|
Store Procedures are invoked explicitly | Triggers are invoked implicitly |
Stored procedure is a user defined piece of code which may return a value (making it a function) that is invoked by calling it explicitly. | A trigger is a stored procedure that runs automatically when various events happen (eg update, insert, delete). |