Here i am presenting an exhaustive list of difference between Stored Procedures and Functions in Database.
1> Functions can be called from procedure where as procedures cannot be called from function.
2> Procedures can not be utilized in a select statement whereas function can be embedded in a select statement.
3> Function must return one and only one value where as Procedure can return any number of values (0 to n).
|
