I want the SQL Server default date to be 0000-00-00, as for some records I have following situations and not sure how can I tackle the default date for every record insert
1. Some records no date at all but I don't want to leave datetime field empty
2. Some records only year and month available
3. Some records only year available.
How can I default the missing information to just 0000 or 00 automatically whenever there is a records inserted.