I agree with Tom as well.

Here's the question and answers

Will this code execute and return a value?

1. You will receive a syntax error

2. No. You cannot call from on SP...

Hugo Kornelis (3/1/2013)

---

It is very easy to create infinite loops that will never terminate. For instance:

DECLARE @i = 0;

WHILE @i < 10;

BEGIN

SET @i = 1; ...

ronmoses (3/1/2013)

---

Without a BEGIN and END defining the body of proc sp1, I assumed it would only use the first statement, like an IF...THEN statement does. Then it would...

+1...

demonfox (2/28/2013)

---

I got it right, but it was a sheer guess on the mind of OP ..

it should have been mentioned as the 4th step..

also, it...

Good question.... Had to stare at it a while due to lack of sleep and too much food. Glad I figured it out and was able to asnwer it...

No No... you mean WhOoPs! 🙂

Good question... +1 for me.

Shame on the typo... I didn't even notice the whoops vs Whoops issue until I read the thread in here.

thanks for the question... was looking for a gotcha.... couldn't find one... answered what I thougt it would be... and was right for a change 🙂

Exactly... I was trying to identify that which had been deprecated. I know Profiler is deprecated in...

Dineshbabu (2/21/2013)

---

Nice and easy one. Initially I overlooked the word WTH and answered the question. After seeing the explaination only i realised it was mispelled and it will act as...

I spent another 2-3 re-reading the phrase because it reads very oddly written...

And the other thing to keep in mind is that if we don't occasionally mention SQL injection attacks and how to prevent them, we run the risk of developers in...

+1. Had to think for a second about it... which is about all I have in thinking power today anyway. 🙂

Yes, I wanted to post above what the fix was in case anybody else runs into this.

If you're going from 2012 SP1 to 2005 SP3 (probably from 2012 of any...