L' Eomot Inversé (10/23/2012)

---

I don't think you're right on that. With intra-bank transfers, the confirmation meessage I get tells me it...

Michael Poppers (10/18/2012)

---

I answered the QotD based on how I received it (STR(123.45, 2, 2)) via email. The Webpage currently lists a different statement (iirc, STR(987.65, 2, 3)) --...

honza.mf (10/12/2012)

---

In the UK at least, such processes work entirely in the bank's favour. Transaction 1...

As usual the lesson is not to rely on the defaults.

I'd have expected a near 100% success rate given the number of similar questions we've had in recent months, but...

I got it wrong, because I've never used identity_insert, so assumed the syntax was correct.

I'm not at all surprised that there...

Is it me, or does the "explanation" for (1) just repeat the incorrect syntax used in the question?

"IDENTITY_INSERT is used to set identity of a particular table. SET IDENTITY_INSERT ON/OFF...

Mine was. Sorry :blush:

That puzzled me as well, so I did some more testing and found that

"final" comes before "initial"

"eleven" comes...

None of the options gave the expected order, so it was obviously a question about the Latin1_General collation rather than case sensitivity.

Luckily I guessed right 🙂

Easy question - if only I'd noticed that it was a table variable!

Guessed wrong, as I'd ruled out "Can inherit rows from other catalog views" on the basis that it is meaningless in this context.

Obviously not!

Implicit conversion isn't ever your friend!

EL Jerry (8/20/2012)

---

I was told once before (by an Oracle DBA) that using COUNT(*) was not a recommended practice as it would cause performance issues because the database engine would...

I got it right - but my list of possibilities was different from the questioner's 🙂

Currently 15% of people think that Count(columnname) on a 7-row table will return a value of 10 😉