Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQLSortOrder

Status
Not open for further replies.
kfincher

kfincher

MIS
Joined
Apr 7, 2003
Messages
6
Location
US
SQL Server 7 Enterprise

What does sort order = 50 define?

What are the possible value for sort order?

Tks
 
Sort by date Sort by votes
From your example this relates to the ORDER BY clause in a select statement. The value defines the ordering sequence of fields in the order by, each field has a unique number defining its precedence.

for example ORDER BY f1,f2,f3,f5
f5 would have a sort order of 5

Possible values can be 1 to number of fields in the order by.

 
Upvote 0 Downvote
Thanks for the reply, but from a setup standpoint. Does 50 mean binary sort order, etc?

on the sp_configure, it shows sort order set to 50.

Tks
 
Upvote 0 Downvote
OK now I understand - this sort order relates to collation. If you run this query SELECT * from master..syscharsets Where ID = 50 that should give you what you are after

 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top