![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
![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
![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. :
![Microsoft Business Intelligence: Insert Null Value in Unique column (Enforcing Uniqueness with NULL) Microsoft Business Intelligence: Insert Null Value in Unique column (Enforcing Uniqueness with NULL)](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjl1QasSKpnyyc-akrhHgAuLgTP4EDKeLN9Z9-lfXG6ebb-ckCtcDizQQ7JZBDxZ9nqCJvsyZ8Ry-2rjax8ezxR99z-MuwwBLbjfZiAvbdBs2BsQfxe80R6d81IV13xD6JG72EZ1nnc-OY/s1600/1.jpg)