<div>
There is another column in the table that is specified as &quot;NOT NULL&quot; in the table definition.<br />
<br />
You need to add a value for any required column(s), for example:<br />
<br />
INSERT INTO dbo.tbl_PS_ScorecardTmp<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (ScorecardID, RequiredColumn1, RequiredColumn2)<br />
VALUES &nbsp; &nbsp; (111, 'A', 0)
</div>


There is another column in the table that is specified as "NOT NULL" in the table definition.

You need to add a value for any required column(s), for example:

INSERT INTO dbo.tbl_PS_ScorecardTmp
                      (ScorecardID, RequiredColumn1, RequiredColumn2)
VALUES     (111, 'A', 0)

<div>
<div class="content wysiwyg-content">
The following SQL Server command text raises the error &quot;column does not allow nulls&quot;<br />
<br />
INSERT INTO dbo.tbl_PS_ScorecardTmp<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (ScorecardID)<br />
VALUES &nbsp; &nbsp; (111)<br />
<br />
The column Scorecard design does allow nulls. Why do I get the error? Thanks
</div>
</div>


The following SQL Server command text raises the error "column does not allow nulls"

INSERT INTO dbo.tbl_PS_ScorecardTmp
                      (ScorecardID)
VALUES     (111)

The column Scorecard design does allow nulls. Why do I get the error? Thanks

SQL Server column does not allow nulls

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.