Calling a user-defined function from vb.net - efficiency questions

Hello Experts,
        I have an efficiency question.   I want to call a user-defined sql-server function from a vb.net application.
Is it efficient to simply called a sql command object with text as in :
        sqlcmd = "Select dbo.myFunction"

OR

Is it more efficient to turn each function into a stored procedure (that does the above)?
I know sql server optimises stored procedures but don't know if it could or would optimise a simple select from a function.
If it doesn't make any difference, I would just as soon use the first method as it saves me creating a lot of stored procedures and cluttering up the database.

Any advice would be most appreciated!

Many thanks
Gail HL
gailhlAsked:
Who is Participating?
 
RonaldBiemansConnect With a Mentor Commented:
I don't think SQL server can optimize much on such a small statement, so I would stick with your first option :-)
0
 
gailhlAuthor Commented:
Thank you very much!   Apologies for taking such a long time to close the question ... I got involved in something and lost track.

Much aprpeciated,
Gail HL
0
All Courses

From novice to tech pro — start learning today.