select 'update ' + table_name + ' set [' + column_name + '] = '''' where [' + column_name + '] is null'
from information_schema.columns
where table_name = 'yourtable'