how can we update null value columns in a table in sql serve

Question

Hello how can we update null value columns in whole table in sql server without using column name? I want to update all null value columns in a table many columns in my table So can we update all null value columns without using column name? Please help me. Thanks in advance. Ankit Agarwal Software Engineer

Priyanka Jain · Answer

Now i am explaining this with the help of example. suppose your table name is tab1 and table have following structures and data so you have to write update tab1 set name='n' where name is null update tab1 set pincode='6' where pincode is null

Iftikar Hussain · Answer

by above query you will get list of column name which are null.

Ankit Agarwal · Answer

many columns in my table so what should be name of columns will we write every column name?

Rosi Sreenivasa Reddy · Answer

hai Hussain can you explain clearly about it?

Iftikar Hussain · Answer

Hi By using the below query you can find all column which are null DECLARE @sql NVARCHAR(MAX); DECLARE @table NVARCHAR(30); SET @table = N'EmployeesBackUp'; SET @sql = STUFF(( SELECT N' UNION ALL UPDATE @table SET ' + column_name + '=1 ' + @table + N' HAVING MAX(' + column_name + N') IS NULL' FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = @table FOR XML PATH('')) 1 11 ''); exec(@sql) Regards Iftikar

Priyanka Jain · Answer

solution is: update tablename set columnname=value where columnname is null