Differentiate between stored procedure and functions?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

There are several differences between stored procedures and functions. These are: -

  • Stored Procedure is very suitable to perform business logic while functions are utilized to do the calculation.
  • Stored Procedure need not hold the return type while Function obligates the return type.
  • A stored procedure can be returned 0 or more values while a function may state just one value.
  • The Stored procedure upholds input and output parameters while the function upholds only input parameter.
  • The stored procedure may be used try/catch for exception handling but it is not be used in a function.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    JDBC interview questions

    What is the full form of JDBC and what is its purpose?

    JDBC stands for Java Database connectivity which is an application that helps in connection for the programming of Java language...

    JDBC interview questions

    What do you understand by JDBC driver and explain its types?

    JDBC drivers are software that enables the Java application to connect with the database..