Something like the following will work
DELETE FROM Table
WHERE ColumnName IS NULL;
GO
The C# tag throws me. You can execute this command from C# using the SqlCommand
class.
UPDATE Table
SET ColumnName="DefaultValue"
WHERE ColumnName IS NULL
1
solved Can remove Nulls from Database using C#?