What is the difference between a function and a stored procedure?

Question

Accepted Answer

Functions return a single value while stored procedures execute multiple SQL statements.

Functions can be used in SELECT statements while stored procedures cannot.
Functions cannot modify the database while stored procedures can.
Functions are called like any other expression while stored procedures are called using EXECUTE statement.
Functions are precompiled while stored procedures are compiled at runtime.
Examples of functions include SUM, AVG, and COUNT while examples of stored procedures include sp_help and sp_who.

Accepted Answer

Function calculates the result of the given input of a program and procedure means its a certain task in a particular order based on the given input

Accepted Answer

function must be return value but procedure may or may not be contain return value.

function can be called sql statement but procedure can not call sql statement

function can compile every time but procedure compile one time

Accepted Answer

Function must returns the values but procedure may contain or may not contain Return values

Accepted Answer

procedure is used to perform particular tasks.
out parameter is used to return output.
can perform DML operations and not call from select statement.
we can call function from procedure.
procedure may or maynot return a value.
there is no need to write return datatype at the time of procedure creation.
procedure compile once until do any modification.

function is used for calculation purpose.
return keyword is used to return output.
cannot perform DML operations and call from select statement.
we cannot call procedure from function.
function must return a value.
need to write return datatype at the time of function creation.
function complie everytime while executing .

Asked in Fiserv and 8 others

What is the difference between a function and a stored procedure?

Interview Questions from Popular Companies