Triggers provide reuse of common code,while stored procedures provide rule processing for common tasks.

Question

Quizplus · Accepted Answer

Triggers are primarily used for automatic execution in response to specific events on a particular table or view in a database, such as for enforcing business rules or maintaining audit trails. Stored procedures, on the other hand, are used to encapsulate common tasks, allowing for code reuse, parameterization, and improved performance.

Triggers Provide Reuse of Common Code,while Stored Procedures Provide Rule