Using one Isnull() function to remove all null values from all columns a table in SQL Server

KapilDevTripathi

Rate me:

2.33/5 (3 votes)

14 Nov 2012CPOL

47.1K

Write a sql query in which we use only one IsNull() function and it will remove all Null values(if any) from entire result set(from all rows)

No downloads associated with this content

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

KapilDevTripathi

Technical Lead Tech Mahindra

India

Working in Tech mahindra, Noida, India. Having more than 7 years knowledge in asp, ASP.net,C#, VB 6.0, VB.Net, XSLT, XML, RDLC report, Crystal Report, SQL Server, MySql, DB2 etc.

Using one Isnull() function to remove all null values from all columns a table in SQL Server

License

Comments and Discussions