Question

What are differences between function and stored procedure in .Net programming language?

Answer 1

The difference between function and stored procedure:

1. Function returns only one value but procedure can return one or more than one value.
2. Function can be used in select statements but procedure cannot be used.
3. Function has only input parameters while Procedure can have an input and output parameters.
4. Exceptions can be handled by try catch block in procedures but that is not possible in function.