The default ORDER BY

Question

The default ORDER BY

Steve Jones - SSC Editor

SSC Guru

Points: 736291
More actions
December 7, 2020 at 12:00 am

#3813604

Comments posted to this topic are about the item The default ORDER BY

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Bob Razumich SSCrazy Points: 2143 More actions · Answer 1

I really thought this was going to be a trick question. I decided that the trick was that it was not a trick. We all tend to overthink these questions sometimes.

Nice start for the week.

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 2

Lordy... Let us hope that MS never makes a DB or Server-Wide setting for this.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

jcelko212 32090 SSCrazy Eights Points: 9303 More actions · Answer 3

I'm just hoping that Microsoft will get around to implementing the ANSI/ISO standard null first or last subclause that goes after the sorting direction. Since it applies column by column, rather than a server-wide setting. You can adjust to what you need. As a flashback to the old days, this is why we used to use all nines or all zeros for the encodings that we wanted to sort always first are always last back in the punchcard days.

Please post DDL and follow ANSI/ISO standards when asking for help.

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 4

It doesn't work just in the old punch-card days. It works fine now, as well. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)