Difference between trigger and stored procedure

Question

Accepted Answer

Triggers are automatically executed in response to certain events, while stored procedures are pre-written code that can be executed on demand.

Triggers are associated with a specific table and are executed when a certain event occurs, such as an insert or update.
Stored procedures are pre-written code that can be executed on demand, often used for complex database operations.
Triggers can be used to enforce business rules or maintain data integrity, while stored procedures can be used for data manipulation or reporting.
Examples of triggers include auditing changes to a table or updating a related table when a record is inserted, while examples of stored procedures include generating reports or updating multiple tables at once.

Top PerfectVIPs Software Engineer interview questions & answers