What is the difference between stored procedure and trigger?

Question

Accepted Answer

Stored procedures are precompiled SQL statements that can be executed on demand, while triggers are automatically executed in response to specific events.

Stored procedures are explicitly called by the user, while triggers are automatically executed by the database system.
Stored procedures can return values, while triggers cannot.
Stored procedures can be used to perform complex operations, while triggers are typically used for simple tasks such as logging or enforcing constraints.
Examples of stored procedures include those used for data validation, data manipulation, and report generation, while examples of triggers include those used for auditing, logging, and enforcing referential integrity.
Stored procedures can be executed independently of any table, while triggers are always associated with a specific table or view.

What is the difference between stored procedure and trigger?

Top TCS N/A interview questions & answers

Top HR questions asked in TCS N/A