-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: SriSamp
Message 6 in Discussion
You should be able to call functions using SELECT dbo.functionName(). Depending on
what your function returns, you will be able to access the result in various ways.
Here is one example: CREATE FUNCTION CountAuthors() RETURNS INT AS
BEGIN
DECLARE @authorCount INT SELECT @authorCount = COUNT(*) FROM authors
RETURN (@authorCount)
END The above code creates a simple function in the pubs database. This function
returns the count of authors from the authors table. Next, here is the C# code that
can access this function. using System;
using System.Data.SqlClient; namespace ConsoleApplication1
{
class Class1
{
[STAThread]
static void Main(string[] args)
{
SqlConnection oConn;
SqlCommand oCommand;
SqlDataReader oReader;
String sqlText;
sqlText = "SELECT dbo.CountAuthors()";
oConn = new SqlConnection("Server=msdevdb;Database=pubs;Uid=sa;Pwd=password");
oCommand = new SqlCommand(sqlText, oConn);
oConn.Open();
oReader = oCommand.ExecuteReader();
while (oReader.Read())
{
Console.WriteLine("{0}", oReader.GetInt32(0));
}
oReader.Close();
oConn.Close();
}
}
}
Here, I'm using a SQL Reader to access the function and the program will print the
result. To answer your second question, using * is significantly slower than using
the column names explicitly. Also, using the column names has lots of advantages when
compared to using *. For one, if your table schema changes, your program using * can
fail, while using the column names explicitly can save you from this trouble. HTH,
Srinivas Sampath MVP - SQL Server http://www32.brinkster.com/srisamp
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
