Member Avatar for Jayashaki
Jayashaki 0 Newbie Poster

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

  • 1 Contributor
  • 0 Replies
  • 116 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.