Stored proc and functions difference including triggers definition and practical example.

Question

Accepted Answer

Stored procedures and functions are database objects used to perform specific tasks. Triggers are used to execute code in response to specific events.

Stored procedures are precompiled SQL statements that can be executed multiple times.
Functions return a single value and can be used in SQL statements.
Triggers are used to execute code in response to specific events, such as inserting or updating data.
A practical example of a stored procedure would be a procedure that updates customer information in a database.
A practical example of a function would be a function that calculates the average salary of employees in a department.
A practical example of a trigger would be a trigger that sends an email notification when a new order is placed in an online store.

Stored proc and functions difference including triggers definition and practical example.

Top On Demand Agility Software Technical Lead interview questions & answers

Popular interview questions of Technical Lead

Top HR questions asked in On Demand Agility Software Technical Lead