Probably stating the obvious here but not even Google is a 10.

Whatever you do, don't get rid of the QOD! And at the very least please ensure that a good proportion of those questions are ambiguous or ill thought through, as...

Surely the only sensible output from running this is: "Query was cancelled by user.";-)

george sibbald (3/19/2010)

---

I don't think I am giving away the farm if I say that if the answer boxes are square there is more than one correct answer, a radio...

Hey... If I'd just disclosed the names of my kids on a blog, my wife would have to change all her passwords! Dangerous things, names.

BackupGuy (11/20/2009)

---

The responses so far are, typically, M$-centric...as if nothing exists outside of the AD domain where the SQL server resides that would ever require access to data in the...

majorbloodnock (11/20/2009)

---

I agree, and I must admit there are...

Ok I'm confusing myself here between authentication and authorisation... which I always do... What I mean is that I'd like to see sql server require both windows and sql authorisation....

Don't think I'd like just sql Authentication... If I were to have a third option I'd go with requiring both sql and windows authentication (not sql or windows)...

worked for me in 2005

Nice question... demonstrates how the subtraction operation implicitly casts the result as an integer data type thus avoiding the error message that '435365' on its own would have caused.

surely nchar(1)?

QUOTATION: I speak Spanish to God, Italian to women, French to men and German to my horse.

ATTRIBUTION: King Charles V (1500–1558), King of Spain and Holy Roman Emperor.

Looks like...

Why? That's the puzzle. It looks as though the optimizer is not really building an intermediate resultset of numeric values, but rather is applying the various conditions...

In 2005 if I'm comparing those instances where it works and those where it doesn't... I'd be interested to see how/whether the execution plans differ.