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.