Wow, that is just bizarre. I wouldn't have called that in a million years, and I don't feel the least bit bad about getting it wrong. Great question!

You just made my day, Mr. Jones. 😀

I didn't even...

I would be happy to correct the explanation but I can find no means of doing so. I assume this ability is restricted to administrators, or else it is...

daniel.gardiner (11/20/2009)

---

I answered correctly but didn't get the point, the answer page tells me that the correct selection is '1' because 'Joe' is the only match (which is the fourth...

I got tripped up on the fact that the string didn't end with %. So I answered the question for 'Jo[^n]%' instead of 'Jo[^n]'. Oops.

Works perfectly for me in 2005.

A neat question, but since I didn't see a reason for any of the implicit conversions not to work, I assumed the one datetime value on the list had to...

Sure, spatial data is useful... so are duct tape, lawn mowers, and pinking shears -- none of which have anything to do with SQL Server. Parshv's question stands.

Me too, I wouldn't have given it a second's thought. Good question!

Ron Moses

It was such a simple question I psyched myself out and assumed it must be a trick. I figured if the answer was DML, the question was too basic...

I also missed the assignment back to the int variable. Oops. It would have been an obvious answer if only I'd paid better attention.

SELECTing into a variable is...

ta.bu.shi.da.yu (8/10/2009)

---

vetri (8/10/2009)

---

Hi,

I tried with these two statements but the second one is not get executing and it says "Incorrect syntax near the keyword 'exists'." What wrong...

10. WHERE clauses - In a WHERE clause, the various operators used directly affect how fast a query can run. Here are the conditional operators used in the WHERE clause,...

Dang it, I knew that was the answer and didn't pick it. That seemed like the obvious "otherwise, why would I ask the question?" answer. But no, I...