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/de...calartopic.asp

Probably is the sample on this page enough

I hope this helps,

Cor

"Bill Nguyen" <bi*****************@jaco.com> schreef in bericht
news:O4**************@TK2MSFTNGP09.phx.gbl...

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

[Chris]

Bill Nguyen wrote:

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.