In contrast, a regular `INSERT` statement retains the null value instead of inserting a default value. The [INSERT ... SELECT * FROM OPENROWSET BULK](../../t-sql ...