What is the difference between procedure and function

The return value can either be a single scalar value or a result set. Functions in programming languages are subroutines used to encapsulate frequently performed logic. Any code that must perform the logic incorporated in a function can call the function rather than having to repeat all of the function logic.

User Defined Functions use zero or more input parameters, and return a single value. Some User Defined Functions return a single, scalar data value, such as an int, char, or decimal value. Benefits of User Defined Functions They allow modular programming You can create the function once, store it in the database, and call it any number of times in your program.

User Defined Functions can be modified independently of the program source code. This means the user-defined function does not need to be reparsed and reoptimized with each use resulting in much faster execution times. CLR functions offer significant performance advantage over Transact-SQL functions for computational tasks, string manipulation, and business logic.

Transact-SQL functions are better suited for data-access intensive logic. They can reduce network traffic An operation that filters data based on some complex constraint that cannot be expressed in a single scalar expression can be expressed as a function.

Stored Procedure may or not return values. Comments, criticism, and suggestions are always welcome. Take our free skill tests to evaluate your skill! In less than 5 minutes, with our skill test, you can identify your knowledge gaps and strengths.

Disclaimer :. Invest In Learning. Submit Query Please Wait Training Schedules. Have Queries? Live Training Schedules. When we try to execute a procedure using select it will through an error stating as above output. Basic difference between Procedure and Function S.

The procedure is an important and frequently used programming construct for a compiler. It is used to generate good code for procedure calls and returns.

It provides code reusability and modularity to the program. Hope the article will be helpful to you and gives you knowledge about function, procedure, and their comparison. So, without any delay, let's start the topic.

In a programming language, function is said to be a set of instructions that take some input and execute some tasks. A function can either be predefined or user-defined. In the C program, a function can be called multiple times to provide reusability and modularity. It may or may not return a value. It is an important programming construct for a compiler. The procedure is used for generating good code for procedure calls and returns.

It does not deal with an expression. It is defined as the set of commands that are executed in order. It is a subroutine or a subprogram in the regular computing language. A procedure always contains a name, parameter lists, and SQL statements.