Read the 67 posts above yours. The explanation has already been given multoiple times.

Or you could read...

IgorMi (9/19/2012)

---

Hugo Kornelis (9/19/2012)

---

Nice question. I almost got it wrong, because I had first overlooked the TOP clause.

However, the official correct answer is still a bit questionable. The result of...

Sorry for the mangled quote, but I did that so...

Nice question. I almost got it wrong, because I had first overlooked the TOP clause.

However, the official correct answer is still a bit questionable. The result of a TOP without...

ronmoses (9/18/2012)

---

I'm confused. The result I'm getting is 8, and I'd be curious to know why.

(...)

This returns 8 with either collation. Can anyone explain why that might be?...

Good question; the explanation could have been better.

"To make this query case sensitive we need to either set the collation level to Case Sensitive or use 'COLLATE SQL_Latin1_General_CP1_CS_AS' in the...

pkosiavelos (9/14/2012)

---

I tried '%[^0-9]%' and it does not seem to work.

create table #test (string char(10))

insert into #test values ('12334')

insert into #test values ('abc')

insert into #test values ('123.3')

insert into #test...

mtassin (9/13/2012)

---

that said... your idea of screwing with somebody by reconfiguring the SSMS client when they are AFK to make SELECT a batch separator... is an awesome idea. And...

Nor would you if...

Alex Fekken (9/13/2012)

---

Thanks Hugo,

so is it correct to summarise this as: the sort occurs (logically) in two phases. The first phase is always case/accent/etc (?) INsensitive and the (optional)...

DugyC (9/13/2012)

---

Sorry to be pedantic, but I feel I have to in this case.

GO, or NotGo, aside not one person can run this complete script without modification or error.

@test-2 is...

Wow, interesting discussion. I see a lot of explanations that miss the ball by a long shot (hopefully, some of them were posted in jest!), some that almost or even...

Raghavendra Mudugal (9/10/2012)

---

Hugo Kornelis (9/10/2012)

---

Good question - though I am waiting for the first person to claim that "error, error" should also be considered correct because they executed the code...

Good question - though I am waiting for the first person to claim that "error, error" should also be considered correct because they executed the code on a server or...

sknox (9/6/2012)

---

Hugo Kornelis (9/6/2012)

---

Rewriting them with APPLY makes them valid:

FROM Table1 AS t CROSS APPLY (correlated subquery) AS s ON s.Col1 = t.Col1

FROM Table1 AS t CROSS APPLY dbo.MyFunction(t.SomeColumn) AS...