Store Procedure Vs Function

Store Procedure Vs Function

S.No	Particulars	Store Procedure	Function
1	Return	No return value.	Must return Value.
2	Parameter	Input/Output.	Input.
3	Call	can't called to Function.	can called to Store Procedure.
4	Mandatory Input Paramenter	not Mandatory.	Mandatory.
5	DML/Select	Allow DML/Select.	Allow Select.
6	Exception	can be handled.	can not be handled .