allow null and assigned default value

Hi,
I am setting the schema of a table,
I am confused abut what is the defference bewteen the two fields:
one allow null and assigned default value
one is not allow null and assigned default value.
Hi,
1. ALLOW NULL with Default value:-
This will allow null values if we exclusvely insert a NULL Into the column
Otherwise a default will be inserted.
2. Not ALLOW NULL with Default value:-
Fire an error if we exclusevely try to insert a NULL value in to the column.
Thanks
Hari
SQL Server MVP
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:%23GNxlOikFHA.3064@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I am setting the schema of a table,
> I am confused abut what is the defference bewteen the two fields:
> one allow null and assigned default value
> one is not allow null and assigned default value.
>
>