Accessing UDF's that return tables

  • Thread starter Thread starter Kenneth
  • Start date Start date
K

Kenneth

Can anyone give a quick example on how to store a Table returned from an SQL
Server User-Defined Function into a DataReader object?
 
select * from dbo.MyUdf('blah')

search in SQL Server Help for this: user-defined functions, return a table
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using SQL Server temp tables with ADO.NET Datareader 1
Output Parameter Returns Nothing 1
UDF in LINQ: "Stored Procedures cannot be used inside queries" 4
Using a DataSet 1
Getting command from LINQ query 3
Can Strongly Typed DataSet contains Stored Procedure Wrappers? 3
Looking for Comments on Code 5
I have a CLR function thet returns IEnumberable (a table) and it has a FillRow function. I am return 3

Back
Top