title: MS SQL Server : primary keys, auto increment, and insert into failing
body: <p>I have this code I am converting from MySQL:</p>
  
  <pre><code>CREATE TABLE "odds_soccer" 
  (
      "id" INT NOT NULL PRIMARY KEY ,
      "checked" DATETIME NOT NULL ,
      "bookmaker" VARCHAR(255) NOT NULL ,
      "gametime" DATETIME NOT NULL ,
      "team1" VARCHAR(255) NOT NULL ,
      "team2" VARCHAR(255) NOT NULL ,
      "odds_1" FLOAT NOT NULL ,
      "odds_x" FLOAT NOT NULL ,
      "odds_2" FLOAT NOT NULL 
  );
  
  INSERT INTO "odds_soccer" ("id", "checked", "bookmaker", "gametime", "team1", "team2", "odds_1", "odds_x", "odds_2") 
  VALUES (null, '2017-03-02 16:00:00', 'example.com', '2017-03-02 04:30:00', 'MYTEAMA', 'MYTEAMB', '3.15', '3.15', '2.70');
  </code></pre>
  
  <p>Only problem is... It barfs that I can not use null for inserting which is fair enough...</p>
  
  <p>But how do I insert a record where <em>I simply want the ID to auto increment</em>. </p>
  
  <p>I have tried various variations - all failing - I must be missing something obvious...</p>