What are differences between Trigger and Stored Procedure?

by weston_dietrich , in category: Technology , 3 years ago

What are differences between Trigger and Stored Procedure?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by van , 3 years ago

@weston_dietrich We can execute procedure explicitly whenever we would like, but trigger can only be invoked on an event fire.We can call a Procedure inside another Procedure but we can not invoke a trigger directly inside another trigger. We can use trigger for transaction purpose but we can not use procedure for transactions.

Related Threads:

What is the procedure in SQL?
What is Trigger?
What are Stored Procedures in MySQL?
How to Use Vue.js Animations in 2025?
What Are the Differences Between Html5 and Xhtml in 2025?
What Is the Difference Between Jquery's .on() and .click() Methods?