Cannot insert the value null sql

NULL is not a value. Improve this answer. Mark Sinkinson Mark Sinkinson 9, 3 3 gold badges 39 39 silver badges 52 52 bronze badges. Now I remember my teacher explaining that a few years ago! StevePettifer In this case, he will need a function to simply replace nulls with some non-null value, during an INSERT statement, so there would be no difference in performance. Horses for courses though. I prefer the neater syntax of ISNULL where you are only testing one value and have no need to support other platforms.

Add a comment. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.

Linked Where sometable is a table with three fields. PK, fieldName1, and fieldName2. You also need to make sure that the identity property on the PK field is set to true. However, if you have a primary key that isn't an identity column, then you do need to specify it, because otherwise it'll try to insert a null and primary keys by default are non-nullable. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?

Collectives on Stack Overflow. Learn more. SQL Server, can't insert null into primary key field? Ask Question. Asked 11 years, 3 months ago. Active 11 years, 3 months ago. Viewed 70k times. I understand the error, but the null value is for my my primary field with an int data type. Any ideas!? Improve this question. A-K Nick Nick 1 1 gold badge 2 2 silver badges 5 5 bronze badges.

Okay I should clarify. I get the SAME error. I got it now guys. Thanks a lot. I'm aware of how relational databases work. Nick: ok, glad we could help. SQL is standardized Conrad I know you posted before me but I thought you updated your post after me. I can't see the timestamp. I'm just kidding around either way. Add a comment. Learn more. Asked 10 years, 3 months ago. Active 2 years, 1 month ago.

Viewed 5k times. Improve this question. Juan Mellado You should really parametrize your queries codinghorror. Add a comment. Active Oldest Votes. Improve this answer. Wil Wil 3, 1 1 gold badge 14 14 silver badges 14 14 bronze badges. Again, figure out where the allocation column is NULL by running your update as a SELECT with some additional columns to help identify the rows and handle that parameter or fix the data.

Edit: See my fix. It won't guarantee that quantityLimit will be updated correctly but it will stop the error. Branko Dimitrijevic Branko Dimitrijevic