title: sql server:Column name or number of supplied values does not match table definition
body: <p>I create a table with fields below in sql server 2016</p>
  
  <pre><code>[ID] int primary key not null,[FirstName] nvarchar(50),[LastName] nvarchar(50),[Gender] nvarchar(10),[Salary] int,[DepartmentId] int
  </code></pre>
  
  <p>I forgot to make ID as entity so I drop it and made a new field with the name new_id as identity(1,1) </p>
  
  <p>now when I insert some rows I get the following error:
  Column name or number of supplied values does not match table definition</p>
  
  <p>I choose database from the top and then make a query with this instructions:</p>
  
  <pre><code>insert into Employees values ('Mark','Hastings','Male',60000,1)
  insert into Employees values ('Steve','Pound','Male',45000,3)
  insert into Employees values ('Ben','Hoskins','Male',70000,1)
  insert into Employees values ('Philip','Hastings','Male',45000,2)
  insert into Employees values ('Mary','Lambeth','female',30000,2)
  insert into Employees values ('Valaries','Vikings','Female',35000,3)
  insert into Employees values ('John','Stanmore','Male',80000,1)
  </code></pre>