Not to nit-pick, but the option is actually called ANSI_NULL_DFLT_OFF, so technically, all the answers are incorrect.

However, the database option is called ANSI_NULL_DEFAULT, which can be set to OFF or...

Looking at the available answers, the only logical response would be that it would fail, since all the other answers have both date and time that doesn't match the input...

Hush! That's probably for an upcoming QotD...

Interesting that arguments are optional until the're used in the function.

Evidently, I wrote much the same thing 4 years ago. 😛

• This reply was modified 5 years, 6 months ago by  Rune Bivrin.

I'm gonna go all "Four Yorkshire-men" on this and comment that back in my day, we'd been glad for ISQL/W. We would use SAF in character mode and be happy!...

Good question!

This is the main reason I avoid ISNULL, if possible.

Another aspect is the nullability of the result. ISNULL will infer that from the nullability of the second argument, whereas...

Well, then. Eventually, your answer might be re-flagged.

And when did you answer the question? I have the same on, but I know I answered before Steve corrected the answers.

Current time is: Not enough coffee?

Somewhere in the back of my head I hear Steve singing:

"Oops, I did it again"

There must be a constraint missing on the table with correct answers...

Having read the actual feedback request, the question makes more sense. I'm not sure why the current implementation precludes application provided start times. Obviously, there would have to be a...

If you need to log time in different time zones then why not simply store the timestamps in UTC format? Then you can build the display logic to convert...

• This reply was modified 5 years, 8 months ago by  Rune Bivrin.

And to be picky, the error really doesn't have anything to do with column sets. It simply addresses the fact that there are more items in the VALUES list than...