ASP.NET

CREATE PROC PRCGETCODE
(
@CITY INT,
@CITY_CODE INT OUTPUT
)
SET @CITY_CODE(SELECT TOP 1 CODE FROM WHERE CITY = @CITY)
............
............. RETURN A CODE OR ZERO, TO GET RID OF NULLS 
...............

    con = new SqlConnection(constring);

    cmdselect = new SqlCommand();

    cmdselect.CommandText = "DBO.PRCGETCODE";

    cmdselect.CommandTimeout = 0;

    cmdselect.CommandType = CommandType.StoredProcedure;

    cmdselect.Connection = con;

    int City_Code= 0;

    try
    {
        con.Open();

      City_Code  =  cmdselect.ExecuteNonQuery();

    }
    catch (SqlException)
    {
        throw;
    }
    finally
    {
        con.Close();
    }
    return City_Code;
}

SreejithAchutan wrote:

I need it urgently.

Declare @TodaysDate As DateTime
Set @TodaysDate  =  convert(varchar,GetDate(),101) --only datepart
Select *  from photos
where convert(varchar,YourDateColumn,101)  = @TodaysDate 

Karthick_gc wrote:

how to call it from Asp.net?

subrat4all wrote:

That means it should not show www.abc.com/*.aspx.