Good Question. Thanks.

Good Question.

When I saw the Count(*) I knew that that was where to concentrate.

David

I got it right for the wrong reason.

I too thought that the 2nd Insert would work.

David

Good Question with a Great Debate to follow.

Thanks.

The Question was easy enough. A few people are asking whether the QOTD should be Test / Teach. To me they're the same thing. If I get a Question wrong...

What I find annoying is that by assigning a value of '' to the Datetime2 variable is that it has gone for '1900........'

My preference would be to set the...

Good Question. The Fact that so many got it wrong shows that it wasn't as easy as it looked.

Love it. Sometimes I miss Steve's Gifts being in a different time zone & country.

Good SQL Server Question. In some Systems Len() would count the Trailing Blank. I usually end up doing Len(Trim() ) just to be on the safe side.

Thanks.

Thanks for the Easy Points

Interesting Question even though I don't see any reason to be using the Datatime Data Type this far into the 21st Century.

My Vote is for DML. I see a Verb, a doing word not a Definition.

Now where do I get my 2 Pints from ? I'm thirsty.

David

Easy Points

After having read Tom's explanation on why it ended up as DateTime. This at least made sense to me.

I would like to think that in the future Microsoft could put...