LL – Laxmi Lal Menaria Blog!

Replace Blank CELLs with NULL Value

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

Posted

in

, , , , ,

by

Laxmi Lal Menaria

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *