title: Updating the code through executes
body: <p>I'm a beginner programmer and I'm trying to learn SQL and I've run into an issue here the question I was given is:</p>
  
  <blockquote>
    <p>Write a procedure <code>UpdateSuggestedPrice</code> that accepts an ISBN number and a new suggested price.If the ISBN does not exist, raise an error message.  Update the suggested price to the new price if there are no errors.</p>
  </blockquote>
  
  <pre><code>Create PROCEDURE UpdateSuggestedPrice (@ISBN char(10), @SuggestedPrice smallmoney)
  AS
  BEGIN
     if @ISBN is null
     Begin
       Raiserror ('Provide a valid ISBN',16,1)
     End
     else
     Begin    
       if (select COUNT(*) from Title where SuggestedPrice = @SuggestedPrice) = 0
       begin
          Select 'Description sucessfully added'
  
          insert into Title (SuggestedPrice)
          values (@SuggestedPrice)
       End
       Else
          Raiserror ('Description already exists',16,1)
       End
     End
  
     Return
  
  -- Here I'm trying to execute the procedure, search for ISBN and 
  -- then update the suggested price, can someone please tell me 
  -- what I'm doing wrong.
  execute UpdateSuggestedPrice @ISBN= '1021031040', @SuggestedPrice = '40'
  </code></pre>