Aram Koukia (12/9/2013)
I think for the NULL values you can set the default value for the column to 0 in the column definition, so when the data is not provided, it will be set at the default value
I do know this is an old post but if you have a column that is a mix of values and nulls, a null value will not be replaced by a default value provided in a default constraint.