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.

Only registered users can write comments.
Please login or register.