Quick questions on Nulls and foreign key relationship. I've currently been asked to default all fields and even foreign key relationships to some default value. Even on left outer joins between rows that may not exist yet we have to set default values types using the isnull feature. My question is this, if a table requires referential integrity, is it ok to set foreign key fields to a 0?
Also, since I'm fairly new at not using Nulls with Microsoft Sql Server, is this a fairly common practice?