Gotta love a table that will only ever accept one row. 😀

Ron

Mark Grout (1/17/2013)

---

Yes, that is...

I guess what I'm not getting my head around is, what exactly is that subquery returning?

(select col1 from TblA2 where TblA1.col2 = TblA2.col2)

Is it returning TblA1.col1? If so that's...

Oh, for sure. I would never have used it...

I just encountered this scenario this past week. The ISDATE() and ISNUMERIC() functions are practically useless when determining whether a string will safely convert to a datetime or numeric...

Ahh... you know, I actually had the mechanics straight, it was the fine details I...

Yeah, I'm gonna need someone to draw me a picture for this one. 😉

ron

Hey, what did I tell you??!!! >>>SMACK<<<

😀

ron

Really nice question. I even did the research on each option, but somehow missed the line about indexed views. Looks like I need to brush up on my...

Hugo Kornelis (12/6/2012)

---

I picked the right answer, but only after thinking about it for a long time - go with Books Online, or go with common sense. So I am...

I only got it wrong due to confusion over the meaning of the phrase "break the relationship". I took it to mean "sever the relationship" rather than "violate the...

Dag-nabbit, that'll teach me to read more carefully. I read it as "how many" and not "which"! Duh. Well at least I got it right in my...

I guess the thing that confuses me is, if the variable @ctr is declared within the try block, and the try block fails, why the variable would even exist to...

Is sp_processdetails actually a thing?

Ron

Whoops. Copy-paste error...