SELECT 'UPDATE table SET [' + name + '] = NULL WHERE [' + name + '] = '''';'
FROM syscolumns
WHERE id = object_id('table')
AND isnullable = 1;
My Journey from Developer to …….?
SELECT 'UPDATE table SET [' + name + '] = NULL WHERE [' + name + '] = '''';'
FROM syscolumns
WHERE id = object_id('table')
AND isnullable = 1;