sp_helpsort System Stored Procedure

Displays the SQL Server default sort order and character set.

Syntax

sp_helpsort

Remarks

Binary sort order is the default.

For the output of sp_helpsort to appear correctly on a client computer, the client must be running the same character set and code page as the SQL Server. For more information about sort orders, see Microsoft SQL Server Setup.

Example

This example displays the name of the server's default sort order, its character set, and a table of its primary sort values.

sp_helpsort
go

Sort Order Description
----------------------------------------------------------------
Character Set = 2, cp850
    Code Page 850 (Multilingual) character set.
Sort Order = 40, bin_cp850
    Binary Sort Order for the CodePage 850 Character Set

Characters, in Order
----------------------------------------------------------------

Permission

Execute permission defaults to the public group.

Table Used

master.dbo.syscharsets