Can user-defined functions be called from the application.

[manohars]

Is it possible to call a user-defined function from a front end or middle-tier component written in vb.net or c#.net. If so, is it possible get the return value, which is either scalar or a table?

Thanks in advance,
Manohar

 

[donutman]

Make you life easy and your program more efficient...convert it to a stored procedure.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[manohars]

No, I just want to know whether we can use it.

Regards,
Manohar

 

[SQLSister]

Just call it from a stored procedure or select statement the same way it would normally be called. Of course all of your code to the ASP page should be from stored procedures for security and efficiency reasons.

Select myFunction(1,203)

This should give you the result of that function assuming it was a scalar function.

A tabular function would be called

Select field1, field2 from myFunction('test')


Questions about posting. See faq183-874