Procedure Vs Function

1.) Unlike Stored Procedure, Function returns only single value.
2.) Unlike Stored Procedure, Function accepts only input parameter.
3.) Unlike Stored Procedure, Function is not used for Insert|Update|Delete data in database.
4.) Unlike Stored Procedure, Function can be nested up to 32 level.
5.) Stored procedure can have 2100 input parameter while Function have up to 1023 input parameter.
6.) Unlike Stored Procedure, User Defined function cannot returns xml data type.
7.) Unlike Stored Procedure, User defined function doesn’t support exception  handling.