title: Why am I unable to create this procedure?
body: <p>I just wanted to thank you all for your great help so far. I have another challenge for you guys and I've been dealing with it trying to get it to work but I might've exhausted myself on this one. I'm a new SQL student learning so cut me some slack if needed.</p>
  
  <p>The goal is to create a procedure that will take update the grade for someone by giving the student id, class, and the letter grade. </p>
  
  <p>Here's what I have</p>
  
  <pre><code>CREATE PROCEDURE AssignGradeToStudent
      @[Class Number] char,
      @student int,
      @Grade char,
  AS
  BEGIN
      UPDATE Enrollment
      SET [Grade] = COALESCE(@Grade,[Grade]) 
      WHERE [Class Number] = [Class Number]
        AND [Student] = Student  
  END
  </code></pre>