title: SQL Server 2008 R2 Insert Stored Procedure Syntax with Identity Field
body: <p>Good Afternoon,</p>
  
  <p>I've written a very basic stored procedure that will be used to insert QuestionText and QuestionStatus into the Questions table with QuestionID int Primary Key set as having Identity.  </p>
  
  <p>The syntax is as follows:</p>
  
  <pre><code>CREATE PROCEDURE InsertNewQuestion 
  -- Add the parameters for the stored procedure here
  @QuestionText varchar(200), @QuestionStatus bit
  AS
  BEGIN
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;
  
  -- Insert statements for procedure here
  INSERT into Questions
  (QuestionText,QuestionStatus) 
  Values
  (@QuestionText),(@QuestionStatus)
  END
  GO
  </code></pre>
  
  <p>When I execute the stored procedure, I receive the following error:</p>
  
  <p>There are more columns in the INSERT statement than values specified in the VALUES
   clause. The number of values in the VALUES clause must match the number of columns
   specified in the INSERT statement.</p>
  
  <p>What is the correct syntax to use to properly insert a record and allow for QuestionID to auto-increment upon each insertion?</p>
  
  <p>Thanks much for your help and guidance.</p>
  
  <p><strong>Updated Stored Procedure Syntax</strong></p>