Remove NULL from all the columns from SQL Table using Excel formula:-

Remove NULL from all the columns from SQL Table using Excel formula:-

 

1. use sp_help to get all the columns:- 

 sp_help  SSAS_AC_DRILL

2. Paste SQL tables columns in excel

3. after that use following formula in excel to create SQL code 

="update SSAS_AC_DRILL set "&A2&" ='' Where " &A2&  " is null"

you will get following as formula output 

update SSAS_AC_DRILL set LT ='' Where LT is null

4. copy and paste following in SSMS and execute:-

update SSAS_AC_DRILL set LT ='' Where LT is null