Prev: Replicate Data Content Only of Computed Column - How To
Next: restore database onto different server - tail of the log?
From: pbd22 on 19 Jan 2010 23:29

Hi.

I am using the following SQLHelper code:

http://www.sharpdeveloper.net/source/SqlHelper-Source-Code-cs.html

I am trying to use a Sql Function to return a dataset and
I simply don't know how to do this using SqlHelper. I
am giving text or stored procedure as options.

Has anybody out there used this class to call a Sql function?

Thanks.
From: Erland Sommarskog on 22 Jan 2010 17:35
pbd22 (dushkin(a)gmail.com) writes:
> I am using the following SQLHelper code:
>
> http://www.sharpdeveloper.net/source/SqlHelper-Source-Code-cs.html
>
> I am trying to use a Sql Function to return a dataset and
> I simply don't know how to do this using SqlHelper. I
> am giving text or stored procedure as options.
>
> Has anybody out there used this class to call a Sql function?

I've never this class before, and I guess you may get better help in a
..Net forum.

Then again, calling a function, is just like running any other SELECT:

SELECT col1, col2, col3
FROM my_func(@param1, @param2)


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: Replicate Data Content Only of Computed Column - How To
Next: restore database onto different server - tail of the log?