Jeff Moden (10/17/2016)

---

Eric M Russell (10/17/2016)

---

I occasionally encounter SQL that was originally coded back in the early '90s, even though it has been migrated to newer hardware and RDMS platforms...

GilaMonster (10/13/2016)

---

20 years ago I was at University. 2nd year specifically, Maths, Physics, Computer Science.

And I'm one of the oldest people at my current company (CEO is 2 years younger...

Nickelodeon

I'm pretty much retired now, so I don't have this problem any more except in the form of having some archaic stuff that won't run on windows 10 and I...

Nice query, but one only has to check query 5 and query 4 to get the right answer, since only one answer option has 5 working and 4 failing. ...

Look more carefully: two of...

Steve Jones - SSC Editor (10/14/2016)

---

I've added a SELECT to all answers.

However, in retesting, I get these answers for the four respectively (cut and paste the code in SSMS 2016).

NULL

Dak...

What a mess. The correct answer would be none of these, since only one of them is a query and it returns NULL. And when this is corrected...

Pressing

accidental duplicate reply deleted

Rune Bivrin (10/11/2016)

---

Ed Wagner (10/11/2016)

---

Okay, that's a little weird. Microsoft has updated the language to allow syntactically incorrect SQL based on popular habits. I see why they did...

David.Poole (10/6/2016)

---

Tom, if the corporate strategy failed but the rogue unit was right then you have a desirable result but for the wrong reasons. The end doesn't justify the...

Lynn Pettis (10/3/2016)

---

Used it years ago when programmatically adding items...

and Western

Laurence Neville (9/27/2016)

---

I often come up against the following challenge, and end up de-normalizing my table design in order to enforce data integrity. I would be interested to hear if...