![Can We Have NULL Value in Primary Key? - Interview Question of the Week #075 - SQL Authority with Pinal Dave Can We Have NULL Value in Primary Key? - Interview Question of the Week #075 - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/wp-content/uploads/2016/06/errornull.jpg)
Can We Have NULL Value in Primary Key? - Interview Question of the Week #075 - SQL Authority with Pinal Dave
![SQL SERVER - Warning: Null value is Eliminated by an Aggregate or Other SET Operation - SQL Authority with Pinal Dave SQL SERVER - Warning: Null value is Eliminated by an Aggregate or Other SET Operation - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/ansi-warning-01.jpg)
SQL SERVER - Warning: Null value is Eliminated by an Aggregate or Other SET Operation - SQL Authority with Pinal Dave
![I'm getting the error ' Cannot insert the value NULL into column 'id', table 'DatingP.dbo.relationship_type'; column does not allow nulls. INSERT fails. ' and I'm not sure how to fix it. : I'm getting the error ' Cannot insert the value NULL into column 'id', table 'DatingP.dbo.relationship_type'; column does not allow nulls. INSERT fails. ' and I'm not sure how to fix it. :](https://preview.redd.it/ppbaog7plu361.png?width=570&format=png&auto=webp&s=81615c85226c1f0a82cd591492dd27469bda0b3c)
I'm getting the error ' Cannot insert the value NULL into column 'id', table 'DatingP.dbo.relationship_type'; column does not allow nulls. INSERT fails. ' and I'm not sure how to fix it. :
![t sql - SQL Server : default values - cannot insert the value NULL into column <UID> table <table> column does not allow nulls - Stack Overflow t sql - SQL Server : default values - cannot insert the value NULL into column <UID> table <table> column does not allow nulls - Stack Overflow](https://i.stack.imgur.com/815Ra.png)