title: Autoincrement through IDENTITY in SQL Server 2012 Management Studio
body: <p>I'm trying to do autoincrement in SQL Server 2012 Management Studio by using <code>identity</code>, but I'm not able to fill in values for incremental column ID. What to fill in insert values?</p>
  
  <p>Part of my code looks like this:</p>
  
  <pre><code>CREATE TABLE G_Members
  (
  ID int(4) IDENTITY(0001, 1) PRIMARY KEY,
  Jméno varchar(20) NOT NULL,
  Nick varchar(20) NULL,
  Příjmení varchar(20) NOT NULL,
  Pohlaví char(1) NOT NULL,
  Datum_Narození date NULL
  );
  
  INSERT INTO G_Members VALUES
  ( 'Martin', 'Mates', 'Škorník', 'M', 01-AUG-1978);
  INSERT INTO G_Members VALUES
  (NEXT VALUE FOR G_Members.ID, 'Ondřej', ' ', 'Panenka', 'M', 29-MAR-1983, );
  </code></pre>