Why we have to perform calculation part in Functions?

Procedure also written the values using out parameter than why we need functions?

Questions by Rakesh057   answers by Rakesh057

Showing Answers 1 - 4 of 4 Answers


  • Jun 30th, 2014

Functions can be used in control statements. For example you can have a function which checks if it is OK to proceed and returns TRUE if everything is fine, you can use that within loop to check if you are ok to continue or should quit. Same thing can be achieved with procedure but you will have to write more code.


  • Jul 1st, 2014

we can use functions in SQL queries and it is not done with procedures


  • Jul 1st, 2014

Procedure also written in out parameter but we can not use procedure in Sql statement.

But if we wrote function and ita cant contain DML operation then we can access this function in SQL queries.

  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.


Related Answered Questions


Related Open Questions