title: SQL Server Identity column does not behave properly?
body: <p>I created a table named <code>tblEmployees</code> with code -</p>
  
  <pre><code>Create table tblEmployees
  (
      EmployeeID int identity primary key,
      Name nvarchar(30),
      Salary float,
      Gender tinyint
  )
  </code></pre>
  
  <p>Then I inserted values-</p>
  
  <pre><code>insert into tblEmployees values ('Akmal', 5000, 0)
  insert into tblEmployees values ('Shakira', 6000, 1)
  insert into tblEmployees values ('Kiron', 7000, 2)
  insert into tblEmployees values ('Jamil', 5500, 0)
  insert into tblEmployees values ('Faul', 4800, 4)
  </code></pre>
  
  <p>But, when the values are shown -</p>
  
  <pre><code>EmployeeID  Name      Salary    Gender
  2           Akmal     5000          0
  3           Shakira   6000          1
  4           Kiron     7000          2
  5           Jamil     5500          0
  7           Faul      4800          4
  </code></pre>
  
  <p>My question is, why EmployeeID column started with 2? And where is 6? Shouldnt this be incremented automatically?</p>