[Solved] Can remove Nulls from Database using C#?


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#?