Well, 29 would have been too easy, and the title of the QOTD hinted at the result not being quite the obvious. Casting to INT always truncates decimals, so it...

Good one!

The problem is that casting to int always removes any decimals, and with the example, 0.289 is actually stored as a value which, when converted with the maximum number...

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

True, dat! So, we're down to the missing alternative of "None", I suppose...

I really don't...

Option one should work, shouldn't it, since it sets the name of all the columns, but uses the old name...

I thought I wouldn't touch this question until it's been reviewed, but I couldn't resist.

Clearly, option 3 wouldn't work, since the original column name is "BillingAmount", and not "BillAmount". In...

I'll defer answering until Steve has sorted this one out.

Well, unfortunately, the documentation is a bit off. The bit about the session settings is correct, which matches what I wrote.

The bit about the database settings is incorrect. The correct...

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 6 years, 7 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...