Removing Null Values From the table without losing data

Atul Warade6y ago

Hi Arti,

Please find below URL

https://dba.stackexchange.com/questions/218200/remove-all-null-values-from-sql-table-at-once

Ananathu Mahesh6y ago

Hi,

You can use either Case statement or ISNULL function in SQL.

1. CASE statement

CASE WHEN month5 IS NULL THEN '' ELSE month5 END AS month5

2. ISNULL function

ISNULL( month5, '') AS month5

similarly, you can do the same thing for remaining columns also.

Amit Kumar6y ago

Hi, Use the below sql query it will definitely update your table which you want.. UPDATE tbl1 SET MONTH1=(CASE WHEN ISNULL(MONTH1,'')='' THEN 1 ELSE 0 END) WHERE ISNULL(MONTH1,'')=''

Laxmidhar Sahoo6y ago

hi

What value you need to replace null

Thanks and Regards

Amit Gupta6y ago

Hi

There were multiple scenario

In Sql server, by default null values will be shown as NULL, if you bind with your gridview, it will shown as blank but if you still want then you can use

IsNULL(month1,'')

Explain more to get better and optimized answer

Jenith Thakkar6y ago

What exect output you want show that so i can give you query based on that