Sql check column is not null

Perhaps in the sql query with a temperary table? Add a comment. Solomon Rutzky Solomon Rutzky Juozas Juozas 10 10 silver badges 16 16 bronze badges.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. 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. Visit chat. Related Hot Network Questions. Viewed 47k times.

Improve this question. David Clarke David Clarke 1, 1 1 gold badge 10 10 silver badges 17 17 bronze badges. Add a comment. Active Oldest Votes. Improve this answer. World Wide DBA This can be further generalized to "All null or not null" by using IN. Nick Chammas This is not so scalable, I have a table with 9 foreign keys and only one should be not null, I prefer MarkStoreySmith 's solution — Amir Pashazadeh. David Clarke 1, 1 1 gold badge 10 10 silver badges 17 17 bronze badges.

Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use , cookie and privacy policy. Copyright by Refsnes Data. Magento 2 Check File Exists Programmatically. Related Posts.

Note :. Leave a Reply Cancel reply Your email address will not be published.