Free help with homework

Why join Brainly?

  • ask questions about your assignment
  • get answers with explanations
  • find similar questions



Difference between procedures and functions

• When the parameter is passed into the procedure; it does not return any value whereas a function always returns a value.

• One of the major differences in both of them is that procedures are not used in databases whereas functions play an important role in returning values from a database.

• Procedures are capable of returning multiple values and the functions are able to return limited values.

0 0 0
Function must return a value, but in Stored Procedure it is optional(Procedure can return zero or n values). Function takes one input parameter it is mandatory ,but Stored Procedure may take 0 to n input parameters.. Functions can be called from Procedure whereasProcedures cannot be called from Function.
1 5 1
The Brain
  • The Brain
  • Helper
Not sure about the answer?
Learn more with Brainly!
Having trouble with your homework?
Get free help!
  • 80% of questions are answered in under 10 minutes
  • Answers come with explanations, so that you can learn
  • Answer quality is ensured by our experts