Hi All,

I am having a problem in writing a stored procedure.

I have a table called as model year which has two fields model year and model status. model year is the primary key column. If the user inputs a model year, the stored procedure should check whether the input is already present in the table or not, if yes it should update with the new input, else insert the new input.

Kindly help me to achieve the same.

Thanks,
Jaya