I have set an MSSQL datetime column to have a default value of
getdate()
... but when I try to insert a row without specifying a value for that column, it throws the error about column mismatches. Am I crazy, or should I not be able to do this?
Table structure and
query examples (RecID is an auto-incrementing identity column)