Maybe, the author exchanged the CAST and the ISNULL:

The right version:

DECLARE @x CHAR(1)

SET @x = CASE

WHEN @x = 'x'...

Thanks for the question!

🙂

Fantastic!

The usual SEVEN!

Here is sp_configure with a simple optimization:

-- Use @configname and try to find the right option.

-- If there isn't just one, print appropriate diagnostics and return.

select @configcount = count(*)

...

Here is the code from sp_configure:

-- Use @configname and try to find the right option.

-- If there isn't just one, print appropriate diagnostics and return.

select @configcount = count(*)

from sys.configurations

where...

In the answer a word is missing "Distributes".

So, NTILE returns the number of the group to which the row...

Tom, re-word the question, maybe I get it right!

Unreadable!

Nick Doyle (8/22/2013)

---

I don't agree that it encourages sloppy coding. You need to know how a language works and be a decent coder to not be sloppy. I...

In the past 10 years, I played a lot with SET identity_insert. I'm a specialist!

Hugo Kornelis (8/19/2013)

---

Mike Dougherty-384281 (8/19/2013)

---

I think I'll continue with the belief that "return" belongs at the end of a procedure. If I ever see anyone in my group using...

cschlieve (8/13/2013)

---

That kind of thinking can get you into a lot of trouble....

Very good explanation!

Here is why the first select may return 1,-1,negative and the second only 1 and negative.

The same side effect of "C" macros:

#define abs(a) (a < 0?...

Good! It's good practise to remember basic concepts!

😀

Easy qotd, but explanation is really confused.

Why do you think that...