Query to delete null or empty values from datatable in sql server

Introduction:

Here I will explain how to write a query to delete null or empty values from datatable in SQL Server.

Description:

In previous articles I explained many articles relating to SQL Server. Now I will explain how to write a query to delete null or empty values from datatable in SQL Server. For that first design one table (UserInfo) in database and enter data like as shown below

UserId	Name	City	Education
1	Suresh	Guntur	B.Tech
2	Nagaraju	NULL	MCA
3	Sai		MBA
4	Madhav	NULL	MBBS

Query to get records without null or empty values

If we want to get the records without null or empty values we need to write query like as shown below

SELECT UserId,Name,City,Education FROM UserInfo WHERE City IS NOT NULL AND City <>''

Output

UserId	Name	City	Education
1	Suresh	Guntur	B.Tech

Query to get records with null or empty values

If you want get records where City contains NULL or empty you need to write query like this

SELECT UserId,Name,City,Education FROM UserInfo WHERE City IS NULL OR City =''

Output

UserId	Name	City	Education
2	Nagaraju	NULL	MCA
3	Sai		MBA
4	Madhav	NULL	MBBS

Query to delete null or empty values from datatable

If you want to delete null or empty records from datatable we need to write query like this

DELETE FROM UserInfo where City IS NULL OR City =''

Output

UserId	Name	City	Education
1	Suresh	Guntur	B.Tech

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email