SELECT Table_name, Column_name, Data_type FROM INFORMATION_SCHEMA.Columns WHERE Is_Nullable = 'YES' And table_name In ( SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_type = 'BASE TABLE' )You can create cursor based on that, loop trhu it and build dynamic UPDATE statement for each column. It can be executed using EXECUTE command or sp_executesql SP.