title: Cannot insert the value NULL into column X, column X does not allow nulls. INSERT fails.
body: <p>I'm new to SQL Server and I am getting this error "Cannot insert the value NULL into column 'Occupied', table 'DBProjectHamlet.dbo.tblGrave'; column does not allow nulls. INSERT fails. The statement has been terminated."</p>
  
  <p>This is my code for the insert followed by the code to create the table </p>
  
  <pre><code>INSERT INTO tblGrave (GraveName)
  SELECT Grave
  FROM tblPlotsandOccupants
  
  
  IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblGrave' AND TABLE_SCHEMA = 'dbo')
      DROP TABLE dbo.tblGrave;
      GO
  CREATE TABLE tblGrave
  (
  GraveID INT IDENTITY (1,1),
  GraveName VARCHAR(MAX) NULL,
  GraveTypeID INT NOT NULL,
  PlotID INT NOT NULL,
  Occupied BIT NOT NULL
  )
  </code></pre>
  
  <p>I'm not trying to insert anything into column Occupied, I don't know why this is happening or how to fix it. I just want to insert values into tblGrave (GraveName). Any help would be great. </p>