Nice, easy question to start the week.

Varchar with no length defaults to 30, as in query B.

Excellent question, Kenneth.

Almost caught by the 5, thinking it selected 1 row on every iteration.

Keep these kind of questions comin'!!

WayneS (9/6/2012)

---

Ron - thanks for the great question. Heck, thanks for all the great questions that you do!

Hugo - thanks for the great clarifications / explanations that you do so...

Thank you for the question Ron, made me think a little bit.

Good question, I don't have too much experience with sparse columns and/or XML, but definitely learned something new today.

Great question, made me think and re-read twice.

Good, easy question to end the week.

I agree with Hugo that there would be no reason to use IDENTITY in a table variable, but it is up to Microsoft to...

Great question, Hugo, got it wrong because of poor researching, but this is something good to have learned.

Great question, Wayne. Made me think and research a lot.

Medulla Oblongata

Kermit

Good question, was also misdirected by BOL but kept my option and got it right.

I also +1 to Hugo's submission, I hope Microsoft fixes it quick.

Good back-to-basics question. I had to re-read the question twice to make sure I understood the purpose of the question.

Good question to finish the week.

Happy weekend, everyone!!!