I'd go with what Hugo said. Also, it's my preference if the question can use some more memorable field names just to try and help make sense of what is...

I'd concur that a rising tide floats all boats; I'm reminded of someone who I knew early in my career who jealously guarded information about how things worked. Pretty sure...

I'm still not 100% if the misdirection was totally intentional, if so it was neatly executed, anyhow I wasn't fooled fortunately.

+1

Just a little help with the intention of some of the string manipulation might make the point clearer.

+1

Just a little help with the intention of some of the string manipulation might make the point clearer.

I'm happy to admit I didn't know that one - it does make sense logically but I had to check.

Raghavendra Mudugal (3/21/2013)

...

- in general practice, as truncate removes all the records and no one wants to remove all the records from the table, only if any exceptional case where...

DugyC (3/8/2013)

---

demonfox (3/7/2013)

---

vinu512 (3/7/2013)

---

The option is wrong....it is not necessary to have an Order By clause if Top is specified in a query.....it should be other way round.....Order By can...

paul.knibbs (3/1/2013)

---

Sean Pearce (3/1/2013)

---

The question is "Will this code execute successfully?"

and the only possible answer is "NO".

Msg 111, Level 15, State 1, Procedure sp1, Line 11

'CREATE/ALTER PROCEDURE' must be the...

I'm going to big up Sunny Republic:

http://www.sunnyrepublic.com/

Their American Brown Ale is among the nicest things I've drunk in a while. St Wites is good just not to my taste, I...

I honestly had not used the OUTPUT clause before, I can see how it would be helpful, so for me it's a good question, regardless of the case sensitivity blip.

I had not realised there is literally a utility for everything, so I guess that's handy to know. I'd used sqlcmd and bcp but it's always good to learn of...

@archie No it counts as being a smartarse (actually I hadn't thought of your answer so it was mildly interesting).

On the editorial, indeed, if you are someone who offers a...

archie flockhart (2/12/2013)

---

I selected "none of these are correct".

The first two are wrong for the reasons stated in the answer.

The third is wrong because the requirements are that the three...

No, I didn't see that coming, fortunately realised I knew nothing about it and did the legwork.