Procedure Vs Function

Explain when do we use a Procedure and when do we prefer using functions.

Showing Answers 1 - 1 of 1 Answers

Deva

  • Feb 10th, 2018
 

Procedure and function both are db objects..both will be stored as pre-compiled objects in our db.. the major difference is

1) Procedure may or may not return a value..but function must return a value in calling area

2) We can execute functions with select statement.where as procedure we can't execute with select statement

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions