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

by

[ad_1]

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

[ad_2]

solved Can remove Nulls from Database using C#?