It was a 50-50 guess as to whether "size" was supposed to mean storage size or number of characters. I guessed wrong 🙁

Surprise that (at the time of writing) the...

Came down to a choice between 0/Error and 9, but since the correct answer (on a case sensitive database) wasn't there, there was only one choice 🙂

The answers only make any sense if there is a missing line that disables the primary key, so I answered on this assumption and got it right 🙂

Unfortunately, everyone else...

I've been using SSMS2014 for about a year. The only time I've ever had a crash is if the connection has been closed (usually because I've left it unattended overnight)...

I guessed right, as I'd have expected B for both, but that would have made the question pointless so it was a question of which one gave A instead 😉

But...

Nice idea, but a shame there was only one answer that had query 1 working. I didn't have to read any of the other queries as this answer had to...

I guessed that it wouldn't execute the procedure ion the 2nd batch, as the parser would detect the recursion and stop it. This seemed to be confirmed when I ran...

I got it right, but on the basis that the table would be empty due to the invalid date formats used. Should have remembered the US-centric nature of this site!

Only 54% correct? I was expecting close to 100%!

At the time of posting, 69% have got this question right, but only 68% chose the second option...

Richard Warr (4/8/2015)

---

It should have been possible to attempt an answer without just running the code. And, given the title of the question, it should have been clear that the...

Like some others, I guessed wrongly that the "trick" to this question was about the schema 🙁

mmmmm, pickle....

.Yes that's true

;but it...

The correct answer is (e) because questions like this promote sloppy coding