title: Cannot insert the value NULL into column 'id', even though Column has IDENTITY property
body: <pre><code>CREATE TABLE Type1
  (
     TypeID       TINYINT         NOT NULL            IDENTITY(1,1),
     TypeName     VARCHAR(20)     NOT NULL,
     Speed        VARCHAR(10)     NOT NULL
  
     CONSTRAINT   TypeID_pk       PRIMARY KEY (TypeID)
  );
  
  
     CREATE TABLE Splan
  (
     PlanID       TINYINT         NOT NULL            IDENTITY(1,1),
     TypeID       TINYINT         NOT NULL,
     PlanName     VARCHAR(20)     NOT NULL,
     Quota        SMALLINT        NOT NULL
  
     CONSTRAINT   PlanID_pk       PRIMARY KEY (PlanID)
     CONSTRAINT   TypeID_fk       FOREIGN KEY (TypeID) REFERENCES Type1(TypeID)                                    
  );  
  
  
  
    INSERT INTO Type1(TypeName, Speed)
    VALUES ('Sample type', '10Mbps'),
           ('Other type', '50Mbps');
  </code></pre>
  
  <p>^Up until there its fine</p>
  
  <p>and then when I enter the following it returns "Msg 515, Level 16, State 2, Line 8
  Cannot insert the value NULL into column 'TypeID' ..... column does not allows. INSERT fails." Statement terminates</p>
  
  <pre><code>   INSERT INTO Splan(PlanName, Quota)
     VALUES ('Some sample name', '500GB'),
            ('sample2, '250GB');
  </code></pre>
  
  <p>I've tried creating the constraints at both column and table level but the second INSERT statement still refused to enter. Double checked via the GUI and 'TypeID' definitely has an IDENTITY property.</p>
  
  <p>I've looked about everywhere and this errors seems to stem from the lack of an IDENTITY property, yet its present in my creation statements and the error still comes up. Tried removing the seed and increment from IDENTITY, still nothing. Also tried inserting the data one row at a time, nothing there either. </p>
  
  <p>P.S If you haven't noticed the actual names have been substituted and other columns rows have been omitted.</p>