create procedure usp_QuestionAnswer { @question_id int=0 , @student_id int =0, @answer varchar(500)=null } AS BEGIN if not exists(select question_id from Answer where question_id = @question_id and student_id =@student_id ) begin insert into Answer(question_id ,student_id,student_answer) values(@question_id ,@student_id,@student_answer) end END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)