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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Much aprpeciated,
Gail HL