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
I am using the following SQLHelper code:
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?
From: Erland Sommarskog on 22 Jan 2010 17:35
pbd22 (dushkin(a)gmail.com) writes:
> I am using the following SQLHelper code:
> 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
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