How to call SQL Function from vb.net

H

Harsha

Hi

PLease let me know how to call the SQL User defined function from the
VB.Net code?

I have sevaral functions in my SQL database which is created out of
database project.

I want to execute these function from VB.Net

Thanks in advance

Sriharsha Karagodu
 
Z

zacks

Hi

PLease let me know how to call the SQL User defined function from the
VB.Net code?

I have sevaral functions in my SQL database which is created out of
database project.

I want to execute these function from VB.Net

User Defined Functions aren't designed to be executed alone. They must
appear as an element in a SELECT resultset, or be the right hand side
of an UPDATE SET, or appear in a WHERE clause. There may be other
places they can appear, but those are the most common.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top