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 Westi 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
Apr 7, 2003
6
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