title: Sql server auto increment going random
body: <p>Ok so I used this code to make the table:</p>
  
  <pre><code>CREATE TABLE Clients
  (
  ID int IDENTITY(1,1) PRIMARY KEY,
  NAME varchar(20) NOT NULL,
  BALANCE int NOT NULL,
  )
  </code></pre>
  
  <p>And it worked good for the first few times and after when i add a new record it gives it like an random id: </p>
  
  <p><img src="https://i.stack.imgur.com/DT0Lq.png" alt="The problem"></p>
  
  <p>I dont really know what the problem is so you might tell me?</p>