Hugo Kornelis (1/17/2012)
A good question, and it's hard to see how anbody could contest the correct answer.Although in the spirit of nitpicking, I could argue that the format one should use would include the column list in the INSERT statement. And the semicolon statement terminator, that in a future version will no longer be optional.
Picky, picky.
Yes, I should have the semi-colon in there. I do like to show code the way I'd want it written in production, and the semi-colon is one I'm struggling to remember as I write since it's an old habit to forgo it.
The columns, it's a good idea, and I've gotten slightly lazy over the years with this.