| Subject | RE: Default column value not applied |
|---|---|
| Author | Leyne, Sean |
| Post date | 2013-04-18T20:56:08Z |
Rick,
The rational is that DEFAULT only applies if the column is not listed in the INSERT statement, by SQL standard.
Assigning a value of NULL is a direct/positive action, so the DEFAULT does not apply.
Sean
> Is it because I'm explicitly trying to insert NULL for the column?As Ivan already responded, Yes
The rational is that DEFAULT only applies if the column is not listed in the INSERT statement, by SQL standard.
Assigning a value of NULL is a direct/positive action, so the DEFAULT does not apply.
Sean