• Easy question, but answer really wrong!

    The DEFAULT is used only if no value is specified for the column or DEFAULT VALUES keyword.

    -- default is triggered

    create table #b (a datetime default getdate())

    insert #b default values

    or

    insert #b (a) values(default)

    -- default is NOT triggered, because a value is specified

    But, insert #b select ''