title: Query for creating a auto increment column in SQL Server CE, C#
body: <p>What is the query in SQL Server CE to create a column that is auto-increment?</p>
  
  <p>Tried with <code>IDENTITY(1,1), PRIMARY KEY</code> .. No luck yet :(</p>
  
  <p>Please guide me, thanks in advance !</p>