Great question!

I've never used DQS, but the correct answer just seemed the most logical.

Got it. But to be precise there won't even be a result set. Not even one with zero rows.

I did what any BI consultant would do: I stuffed the numbers into Excel and did a Power Pivot.

Hugo Kornelis (5/2/2013)

---

However, to do some nitpicking:

1. If I were to try this code on my system, I would get five errors. All system table (*) names are completely lowercase,...

tl;dr

Well, the question is a good one, and I got it right, but if I see code like that I reach for the shot gun.

That was ...

... interesting:rolleyes:

And certainly not views that do [font="Courier New"]SELECT *[/font]

I couldn't even remember what an SPN was, but I figured -R should be RESET, and -D should be DELETE. That left -L for LIST. Good thing the tool writers...

ronmoses (6/25/2012)

---

I see no problem with the wording. Can a table variable have indexes defined, yes or no? Yes, it can. That's all that was asked -...

There are no ways to DEFINE indexes on table variables. Indexes may or may not be created by the implementation when you define constraints, but that is an implementation detail.

Great question!

It highlights something which could be considered a bug. It's certainly not something you would expect from reading the documentation on CREATE TYPE.

Being someone who actually used sp_addtype "back...

This question is just completely broken. There's a big difference between "preferred" and "valid". And to claim that varbinary(max) isn't a LOB is a bit daft.

While I find the question slightly pointless, I have to say I'm more than a little surprised that so many got it wrong. The question made it perfectly clear that...

Richard M Karpel (12/16/2010)

---

Now, I read the section highlighted in BOL, and I expected to get the not defined error message, but I would need to look further and see...