Now this one still bothers me...

Why does it execute the no part after the 8125 error?

By the way, it only executes it with the following SET options:

SET XACT_ABORT OFF

SET ANSI_WARNINGS...

Well, you got me - I confess - I cheated at least once in the QotDs.

But that is probably true for most of us - sometimes we just cannot withstand...

Wow, so many replies - I'd chime in and say the answer is:

NULL

Reason:

The previous statement is unknown, therefore the outcome of the first SELECT @@ROWCOUNT is unknown, therefore the whole...

Well, the whole point here probably is that SQL Server nowadays has no issue transforming many query types (especially these simple two liners), which are semantically equivalent. Therefore the plans...

Well you posted a question and I thank...

Hm this is still not correct - and even more important - I made an error myself - the IN clause is not only the list of values, it also...

Sorry, but "IN" standalone is not a predicate, especially in the case where you have to decide between answers operator and predicate. Explanations (and distinctions between the terms) were given...

Dave62 (1/7/2010)

---

I can understand the confusion with this question since msdn refers to IN many different ways. A number of msdn links have already been posted to defend different...

I agree that the given answer is wrong.

IN is an operator but can be used in an expression like "a IN (1,2,3)".

The expression in this case is a predicate, and...

honza.mf (12/14/2009)

---

As said in...

Hm, is someone able to explain this?

Same code as before, but positioned order by (1 instead of i) and "-" as separator for better readability.

SET NOCOUNT ON

create table #xxx (i...

Please note that the data of this table fits in one data page - therefore a table scan is nothing more than reading one page of data. And doing row-id...

This was a very nice one! Out of curiosity - did you realize this via testing or is there official info somewhere in BOL?

Here is some stats for those interested:

name...

That is actually a good question and unfortunately I have no idea 🙁

Hi Kevin,

I think that is not true.

Try select isnumeric('$$') for example.

It will evaluate to false, although this character...