Replace Blank CELLs with NULL Value

SELECT 'UPDATE table SET [' + name + '] = NULL WHERE [' + name + '] = '''';' FROM syscolumns WHERE id = object_id('table') AND isnullable = 1;