title: MSSQL insert not working
body: <p>I'm doing excercises from the db kroenke book. Anyone can see why this insert:</p>
  
  <pre><code>INSERT INTO PRODUCT_SALES VALUES(41197, 3, 'VK001', 1, 14.95, 14.95);
  </code></pre>
  
  <p>doesn't work on the following table:</p>
  
  <pre><code>CREATE TABLE PRODUCT_SALES(
          TimeID          Int                 NOT NULL,
          CustomerID      Int                 NOT NULL,
          ProductNumber   Char(35)            NOT NULL,
          Quantity        Int                 NOT NULL,
          UnitPrice       Numeric(9,2)        NOT NULL,
          Total           Numeric(9,2 )       NULL,
          CONSTRAINT      SALES_PK
          PRIMARY KEY     (TimeID, CustomerID, ProductNumber),
          CONSTRAINT      PS_TIMELINE_FK FOREIGN KEY(TimeID)
                                  REFERENCES TIMELINE(TimeID)
                                          ON UPDATE NO ACTION
                                          ON DELETE NO ACTION,
          CONSTRAINT      PS_CUSTOMER_FK FOREIGN KEY(CustomerID)
                                  REFERENCES CUSTOMER(CustomerID)
                                          ON UPDATE NO ACTION
                                          ON DELETE NO ACTION,
          CONSTRAINT      PS_PRODUCT_FK FOREIGN KEY(ProductNumber)
                                  REFERENCES PRODUCT(ProductNumber)
                                          ON UPDATE NO ACTION
                                          ON DELETE NO ACTION
          );
  </code></pre>
  
  <p>The format looks fine but getting this error:</p>
  
  <pre><code>Column name or number of supplied values does not match table definition.
  </code></pre>
  
  <p>Thanks!</p>