What is the difference between Triggers and Stored Procedure?

Question

Sumit Kesarwani · Answer

Stored Procedures are called by the programmer wherever it wants to fire but triggers fired automatically when insert, delete, update occurs. And triggers can be implemented to tables and views only where as stored procedure used in the database independently.

interview

What is the difference between Triggers and Stored Procedure?

Can you answer this question?

1 Answers