jfogel (6/27/2012)

---

I agree now I know the answer.

But it could have been - it was the point of the previous question in this...

No it's not. Just because it is created for one purpose doesn't mean...

That's exactly the basis on which I answered "None unless the rest of the statement creates one", which I...

Baloney...

I took a risk and made the correct assumptions, so guessed the right answer 🙂

But strictly speaking, the answer should be "false, false".

A Temporary Table can have primary keys ...

A...

Got it right, seemed an easy guess 🙂

But when I then did a bit of research, it appears that FOR ATTACH will also work if the database had a single...

Am I allowed to complain that I got an error because I have no such database as Adventureworks? 😉

I knew that repair_fast no longer worked, but guessed wrong that it...

Presumably the 21% who answered "0" didn't read the discussions following the previous question 🙂

I can't believe that 21% have currently got it completely wrong, thinking that OR has precedence over AND! Hopefully they're just all misunderstanding what 'precedence' means 😉

That's what we do (MTS in our case). Has...

Hugo Kornelis (5/23/2012)

---

Only when you declare an explicit transaction AND you don't want to add explicit error handling AND you are fine with the default error handling with XACT_ABORT set...

Good question, but not sure about the explanation, which talks about implied transactions even though this one is explicit . The issue surely is that statement failure doesn't cause an...

L' Eomot Inversé (5/22/2012)

The really scary thing is that more than 10% of people responding up to now got it wrong. They don't know what SQL's /...

Good question. I suspect there'd have been fewer correct answers if "1" was an option!

dpathak02 (5/15/2012)

---

Well, there is a difference in "see" and "view"! Joe can see the Agent folder but he can not view/access the folder. Based on this interpretation, I got it...