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

Tags:

Comments

Leave a Reply

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