Diff between stored procedure and functions

Question

Accepted Answer

Stored procedures are precompiled SQL queries stored in the database, while functions are reusable blocks of code that return a value.

Stored procedures are stored in the database and can be called by applications, while functions are stored in the database but can also be called from within SQL queries.
Stored procedures can perform multiple operations and can return multiple result sets, while functions are designed to return a single value.
Stored procedures can have input and output parameters, while functions can only have input parameters.
Stored procedures are typically used for complex business logic, while functions are used for calculations or data manipulation.
Example: Stored procedure to update employee details, function to calculate total sales for a given period.

Popular interview questions of Software Developer