How to retrieve a returned SQL function value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, friends,

There is a function in SQL Server 2000, which return a number. How can I
retrieve this value in my C#.net app using ADO.net? Any sample source code?

Thanks a lot.
 
You can use SqlCommand to execute a T-SQL to return the value.

Example:

SELECT ColName = dbo.Function(Arg)
 
Back
Top