1. The function of the storage process is more complex, and function realization of functions targeted stronger,
2. The stored procedure is usually as a separate part to perform, and the function can be called as a part of the query,
3. The stored procedure can return parameter, the result set, the function return value or table objects,

CodePudding user response:

The

refer to the original poster night you ruin & amp; Ink heart response:

1. The function of the storage process is more complex, and function realization of functions targeted stronger,
2. The stored procedure is usually as a separate part to perform, and the function can be called as a part of the query,
3. The stored procedure can return parameter, the result set, the function return value or table objects,

I think the biggest difference is that the stored procedure does not return data, a function can return data,