How to retrieve the returned function value?

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

Guest

Hi, friends,

I need to call a function of SQL Server 2000. I tried to use
DataSet.SelectCommand by passing a stored procedure command, and then fill
the dataset. This works fine with store procedures that return record sets.
But failed this time. What is correct way to do this? Thanks a lot
 
What do you you do exactly ?

I would try SELECT * FROM MyFunction() instead of calling the function as a
stored procedure...

Patrice
 
I wrap it in SQL like so:
Select dbo.MyFunction('arg1','arg2')
Note that I could also run this line in Query Analyzer.

I then execute the SQL and store the results as a DataTable (if the function
returned data). I built a method in our DataLayer to make this easier:
DataTable ExecuteSql(string strSqL) {...}


Tim
http://timstall.dotnetdevelopersjournal.com/
 
Back
Top