The difference mejor between procedure and function is that function must return value. that should be only single and function can pass any no. parameter but come out only one value only using return statement.

procedure can pass any parameter and came out any no. of values there no any RETURN word.

1.The major difference between procedure and function is that procedure is to be compile only one time and vice versa.Execution of procedure is faster then function

2.Function can be used in select Queries statement but in stored procedure it's not possible.

3.Fuction can return a single value only.Stored procedure return more than one value.

function returns a value

procedure doesnot return a value

SP excepts

SP Accepts both i/p and o/p paramateres where function accespts only i/p paramateres fuction can be used in select stmt as well as function can be used as user defined datatype