Dang! You stole my thunder... I thought up a similar question about a week ago, just didn't get around to submitting it yet...

Thanks! 😉

angeloc (1/16/2013)

---

well that's interesting. Certainly wouldn't...

ronmoses (1/16/2013)

---

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...

Data conversions with possibly unclean data; computations that could generate an overflow,...

Good question. I had to do a bit of research - I knew it wasn't allowewd in inline functions, but was unsure about multi-statement and scalar functions.

The link provided in...

Not just inserts into a table variable, all modifications to table variables are retained after a rollback.

Other things that are not rolled back are assignments to scalar variables, identity values...

I'll have to go for Paul White. 😉

Oops, that is of course...

I don't really agree with the answer marked as correct.

NOT IN can only be used in limited cases. The comparison condition must be single-column, and there must not be any...

Using Management Studio, create the stored procedure as specified in the question, but add a command...

If this is an easy starter for a series of questions that gradually builds up, then it's sort of okay - though probably TOO easy.

As a stand alone question, I...

Hi Brett,

The problem is that you are combining a check for all numbers and a cast to integer in a single query. The optimizer is free to carry out those...

L' Eomot Inversé (1/7/2013)

---

This would have been a good question and easy to get right if the schemaname had been spelt "Sales" instead of "SALES". However, I happened to...

Dineshbabu (1/7/2013)

---

simply I selected one to see the explaination and understand the qstn. Really i didn't understand what the qstn is delaing abt...

Can anyone xplain in detail. If already xplained...

Not happy with the question. Most of my problems have already been discussed - UNIQUE constraints do allow NULL values (and the "choose 4" made me think that the second...

L' Eomot Inversé (1/2/2013)

---

I had in fact broadened the topic to describing methods I would suggest for finding the...