Difference between functions and stored procedure in SQL.

Question

Accepted Answer

Functions return a single value while stored procedures can perform multiple operations and return multiple values.

Functions return a single value while stored procedures can return multiple values.
Functions are used for computations and return values, while stored procedures are used for executing a series of statements.
Functions can be called from within SQL statements, while stored procedures are called using the EXECUTE command.
Functions cannot modify the database state, while stored procedures can.
Example: Function to calculate the square of a number vs Stored procedure to update employee salary.

Popular interview questions of Senior Software Engineer