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"
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!