SQL Server cannot insert value NULL into column IDs (columns do not allow null values to be resolved) _mssql

Error behavior:

Microsoft OLE DB Provider for SQL Server error ' 80040e2f ' cannot insert value NULL into column ' id ', table ' Web.dbo.dingdan '; column does not allow null values. INSERT failed.

/untitled-2.asp, line 115

Reason Analysis:

SQL database, the ID column identification specification is not set to Yes when the table is established. So when you create a table, you must set the ID to automatically increase the ID, identity and so on.

Solution:

Click on the table, modify, set ID column identification specification as "yes", as shown below.