- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Difference Between Trigger and Procedure
In this post, we will understand the difference between trigger and a procedure.
Triggers
It is implicitly invoked when an event such as INSERT, DELETE, and UPDATE occurs in a table of a database.
Nesting of triggers can be achieved using a table.
A trigger can’t be called or defined inside another trigger.
Transactional statements such as ‘COMMIT’, ‘ROLLBACK’, ‘SAVEPOINT’ can’t be used in triggers.
They are used to maintain referential integrity.
This is done by keeping a record of the activities performed on a table.
No values are returned in a trigger.
No value can be passed as a parameter to a trigger.
Syntax to define a trigger:
CREATE TRIGGER trigger_name
Procedures
It is called explicitly by a user or an application using statements like ‘exec’, ‘EXECUTE’, or a ‘procedure_name’.
It can be called as well as defined inside another procedure.
Transactional statements such as ‘COMMIT’, ‘ROLLBACK’, ‘SAVEPOINT’ can be used in procedures.
Procedures are used to perform tasks that are specified by users.
Values can be passed as parameters to procedure.
It can return any value between 0 and ‘n’.
Syntax to define a procedure:
CREATE PROCEDURE procedure_name
- Related Articles
- Difference between Function and Procedure
- Difference between stored procedure and triggers in SQL
- How to set delay for MySQL trigger/procedure execution?
- What is the difference between MySQL stored procedure and function?
- Difference Between & and &&
- Difference between Voltage Drop and Potential Difference
- Difference between C# and .Net
- Difference between Process and Thread
- Difference between Concurrency and Parallelism
- Difference between localhost and 127.0.0.1?
- Difference between Bootstrap and AngularJS.
- Difference between C and C++.
- Difference between Java and JavaScript.
- Difference between NodeJS and AngularJS
- Difference between Normalization and Denormalization
