One dev just asked me
"If you have a table with an autogen id column, and a datetime column which defaults to now() (dev speak for CURRENT_TIMESTAMP
) can you just insert rows without adding anything else?"
Hmmm I thought sounds bizzare insert a row without adding any other data................
I don't think it would work.... how do you do the insert?
You have to add something to the row to get it to generate an instance of a row and bind it to the table. i.e. a data item into a third column.
(Time to educate with extreme predjudice)
Hiding under a desk from SSIS Implemenation Work