LL – Laxmi Lal Menaria Blog!
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:
Your email address will not be published. Required fields are marked *
Comment *
Name *
Email *
Website
Save my name, email, and website in this browser for the next time I comment.
Leave a Reply