stored procedure

Question

Hi friends Im having 2 dropdownlist.In the 1st one im having years. Here my pbm is i want to display the file no(into the DDlist2) according to the selected year in the DDlist1. Please tell me the stored procedure query for this pbm

Rajesh S · Answer

Hi friend i hope it may help you create procedure sp_name @year int as begin select fileno from your_table_name where year(datetime_column_name)=@year end

Manish Dwivedi · Answer

Hi Use datepart in your datetime column like that Create Procedure NameOfSp ( @year int ) as Begin select fileno from table where DATEPART(YEARDateTimeColumnName)=@year End

Krishna Garad · Answer

you may use like this Create Procedure NameOfSp ( @year int ) as Begin select fileno from table where year=@year// from ddlyear End