Home > DeveloperSection > Blogs > Difference Between Function and Stored Procedure

Difference Between Function and Stored Procedure

Database Database 
1 Comment(s)
 4486  View(s)
Rate this:

Difference Between Function and Stored Procedure

1. A function is a subprogram written to perform certain computations and return a single value. 

2. Functions must return a value (using the RETURN keyword), but for stored procedures this is not compulsory.

3. Stored procedures can use RETURN keyword but without any value being passed. 

4. Functions could be used in SELECT statements, provided they don’t do any data manipulation. However, procedures cannot be included in SELECT statements. 

5. A function can have only IN parameters, while stored procedures may have OUT or INOUT parameters. 

6. A stored procedure can return multiple values using the OUT parameter or return no value at all.

For more details about Stored Procedure you can click on the link below..


By Manish Sahu on   3 months ago

Your words increase my knowledge for sure. Thanks

Don't want to miss updates? Please click the below button!

Follow MindStick