Hi
There are 3 type functions in Sqlserver 2008. These are
1.Scalar function
2.Inline scalar Function
3.Table valued Function

Scalar Function: It is used to return the single value from database.
Inline Scalar Function:It is similar to scalar function but it doesn’t contain function body.It’s means doesn’t contain Begin/End block.
Table-Valued Function:It is used to return the table data type.

Here i m going to show to how to call simple scalar function in asp.net

Step1:Create the Scalar function in database like this

CREATE FUNCTION [dbo].[Multiply](@A int,@B int)

RETURNS int
AS
BEGIN
Return @A*@B
END

Step2: Create one simple page and write the code on click event like this

protected void Button1_Click(object sender, EventArgs e)
{
int a1 = Convert.ToInt32(TextBox1.Text);
int b1 = Convert.ToInt32(TextBox2.Text);
SqlConnection con = new SqlConnection("Data Source=.\\sqlExpress;Initial Catalog=Test;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Select dbo.Multiply(@a,@b)", con);
cmd.Parameters.AddWithValue("@a", a1);
cmd.Parameters.AddWithValue("@b", b1);
con.Open();
Label1.Text = Convert.ToString(cmd.ExecuteScalar());
con.Close();
}

Hi
Today i was working on one of my personal project, there was requirement to filter the field from database on basis of case sensitive. For example user has given password “TEST” then database should not accept “Test” as input password.

Sqlserver default it will be in-case sensitive. We have to make it case sensitive like this

We can do using so many approach like this

First Method

Select EmpName from tblEmp where BINARY_CHECKSUM(EmpName)=BINARY_CHECKSUM(‘Hello’)

Second Method

Select EmpName from tblEmp where EmpName=’Hello’ COLLATE SQL_Latin1_General_CP1_CS_AS

Select EmpName from tblEmp where EmpName COLLATE Latin1_General_CS_AS=’Hello’