title: Auto-increment my primary key SQL Server 2012
body: <p>I'm using SQL Server 2012, I want to add an auto-increment to my primary key I don't know the exact syntax so i tried this but it obviously won't work !</p>
  
  <p>Help please !!!</p>
  
  <pre><code>ALTER TABLE dbo.Equipe alter numero_equipe add  IDENTITY(9999,1)
  </code></pre>