That's far too...

Mojo rojo y mojo verde

Good question, but the explanation is a little too prescriptive: "FROM LOGIN" is an allowed alternative to "FOR LOGIN"

I have to disagree with the two previous posters. The question and answer are not the least vague, they are both absolutely clear and the answer is utterly wrong.

The...

The answer could usefully point out that BoL gets it wrong - it gives a syntax that permits only one option to be permitted per call.

Oh what fun.

I like the first option.

I wonder if anyone was confused about what the antecedent of that final "it" was? Since not everyone here has English...

SQL Kiwi (11/22/2011)

---

L' Eomot Inversé (11/22/2011)

---

Nice question, but only works for non-empty tables.

The reason it doesn't work for empty tables is an excellent illustration of SQL's idiotic confustion between...

It's a good question. And the explanation, despite Hugo's comment, is just fine (except that the reference that Hugo gives would have been useful).

Hugo Kornelis (11/23/2011)

---

Interesting question. My gut...

Evil Kraig F (11/22/2011)

---

Pourquoi contredire une femme ? Il est tellement plus simple...

SQLRNNR (11/22/2011)

---

L' Eomot Inversé (11/22/2011)

---

SQLRNNR (11/22/2011)

---

L' Eomot Inversé (11/22/2011)

---

Evil Kraig F (11/21/2011)

---

Tom: Christie Brinkley? I've seen that pose somewhere on one of the 80's models, but well, it's a...

OK, is this one better?

I had a look in IKEA in Arrecife a couple of years ago, and was appalled at the office chair selection there;...

SQLRNNR (11/22/2011)

---

L' Eomot Inversé (11/22/2011)

---

Evil Kraig F (11/21/2011)

---

Tom: Christie Brinkley? I've seen that pose somewhere on one of the 80's models, but well, it's a bit common and tiny....

There's another way (not particularly efficient):

select substring(convert(dateadd(SS, <seconds>,'2000-12-31T00:00:00'),126),15,5). That will give you 02:21 for 141 seconds; if you want to change the : to some other string and...

Nice question, but only works for non-empty tables.

The reason it doesn't work for empty tables is an excellent illustration of SQL's idiotic confustion between emptiness and nullity - only...