Function to return a single value from an SQL statement

[Bill Nguyen]

VS.NET 2003
SQLserver 2000

I need to create a function to return the single resulting value from an SQL
statement.
For example, "Select max(amount) from tableA"
I would like to reuse the function whenever I can.

Thanks a million

Bill

 

[Cor Ligthert [MVP]]

Bill,

What and where you mean with reuse is something I don't understand.

However for returning a single value is the
command.executescalar

http://msdn.microsoft.com/library/d...qlclientsqlcommandclassexecutescalartopic.asp

Probably is the sample on this page enough

I hope this helps,

Cor

 

[Chris]

VS.NET 2003
SQLserver 2000

I need to create a function to return the single resulting value from an SQL
statement.
For example, "Select max(amount) from tableA"
I would like to reuse the function whenever I can.

Thanks a million

Bill

This more like an SQL question than a VB question. You can do this as a
Stored Procedure or as a User Defined Function in SQL Server. Which you
need depends on how you plan to use it.

Chris

 

[zacks]

If he uses a User Defined Function, he will still need a query to
obtain the result.