| (1)The major difference between procedure and function is that function return value that should be only single and function can pass any no of 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.
(2)Other difference between procedure and function is that procedure is to be compile only one time. Execution of procedure is faster then function.
(3)Fuction can return a single value only.Stored procedure return more than one value.
(4)Function can be used in select Queries statement but in stored procedure it's not possible. | | |