if we specified "NOT NULL with Default" it will take default values in the field if the field is null
my questions are
1) can we set any default value instead of '0' for numeric and 'NULL' for alpha?
2) if we use NOT NULL with Default, then 0 is a valid data in the same filed the how we can differentiate.
eg: Empid is created with NOT NULL WITH DEFAULT option and field is a numeric field then for empid '0' is valid empid, then how we can find out the null values through querry?