I had to make a guess as to the author's intention and preparation.

Did he actually try the code himself? In that case, it is a nasty trick question, because everything...

L' Eomot Inversé (11/30/2012)

---

Nor can you claim that by default the candidate key choisen as the target for a foreign key relationship is the primary key, since there is no...

L' Eomot Inversé (11/30/2012)

---

The reference given in the "explanation" is to a description of a rather old version of SQL Server - not sure whether it's 7.0 or 6.5, as...

Since there is already so much criticism for the question and the answer options, let me point out that this question at least is a whole lot better than the...

KWymore (11/28/2012)

---

It...

Steve Jones - SSC Editor (11/28/2012)

---

I let this one through since it was interesting and the execution plan shows "Query 1", "Query 2", etc.

I suspect there is something happening here...

Dave62 (11/28/2012)

---

I came across this odd behavior in SSMS the other day when I was looking at estimated execution plans and thought I'd share it with the community.

Sorry if some...

Koen Verbeeck (11/27/2012)

---

That's the difference between the Belgians and...

That is a very polite way to put it.

I'll be more clear: the explanation is rubbish! The default is...

Probably because the author of the question realized that it would have been so...

vk-kirov (11/22/2012)

---

Another question about different stuff 🙂

An interesting example of inserting one string into another. Never thought it could be done that way. I always did it using something like

SELECT...

codebyo (11/21/2012)

---

It seems many people had the idea that FILESTREAM is a data type and not a column...

mbova407 (11/20/2012)

---

The banker's rounding rule is completely unrelated to today's question. What you see in this question is that float cannot represent the .65 fraction in a finite amount of...

marlon.seton (11/19/2012)

---

Now is somebody going to tell me function a exists with this capability? If so, I suggest PARSENAME is redundant as its functionality is already present. If...

rmechaber (11/19/2012)

---

You know, in fact I don't have any such source, nor can I locate one with Google. My memory is quite clear that the manuals that came with...