Huh? Why?

SELECT TOP ... without ORDER BY is like saying "give me the first by any order of...

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