Quacks101
Reputation: 293
Delete ROW where Value in column is NULL
How do I delete out any rows from a table named:
bhxsql2014-dev.dbo.EUACTIVESTORES
Where the column [Store No] has a NULL value
I'm using MS SQL Server Management Studio
Upvotes: 11
Views: 59657
Answers (1)
Pawel Czapski
Reputation: 1864
Here is what you need:
delete from [bhxsql2014-dev].dbo.EUACTIVESTORES
where [Store No] is null
Upvotes: 22
Related Questions
- How to delete all rows that have NOT NULL in one specific column?
- How to delete a row in SQL based on a NULL condition
- How to delete null column data in SQL Server
- Query to Delete Rows where Columns Match or are NULL
- Delete all row in a table where all content are equals to NULL
- Delete rows where all columns (except ID) are NULL
- remove all NULL valued rows from table?
- Deleting row with a blank column value
- SQL Delete values including NULL
- how we can delete column when All data IS Null