??
Ghassan, June 21, 2016 - 7:38 am UTC
"its probably more of a philosophical debate than a technical one."
Not really. For example out parameter and nocopy hint are not philosophy topics but technical. And the li diff list is shortless .
Rahul Gupta, June 22, 2016 - 10:21 am UTC
@Ghassan : I asked the question in context of a very specific case.
It was not a question of differences between a Function and Procedure in a generic sense.
I got what I was looking for.
Thanks a lot for taking out time to answer this question, Connor.
June 23, 2016 - 1:54 am UTC
GLad we could help out, and thanks for the feedback
Followup
A reader, June 23, 2016 - 5:05 am UTC
Yes first of all countless thanks to Connor and all asktom team for what they do to us.
Still the questions in this site are to be clear for everyone to avoid redondant ones
And I still think that Connor's assertion above still wrong whether or not this responded to a specific need.
Still valid?
A reader, July 31, 2018 - 3:05 pm UTC
Someone says." There is one more difference between stored procedure and functions that stored procedures compiled only once and can be called again and again without being compiled each time, this improves performance and saves time, on the other hand functions compile each time they get called"
Is that true?
If yes is this still true for functions in packages.
Q2 what is your viewpoint if a function is used to di a business stuff like inserting controlling updating data in multiple tables and returning status if exceptions occur. Should keep it or rewrite it as procedure?
August 01, 2018 - 12:40 pm UTC
Re 1: Functions are definitely not compiled each time you use them.
Re 2: As I said, *my* preference is not to use functions for that, but I there is not a *technical* reason for not doing so.