sp_helpsort (T-SQL)

Displays the Microsoft® SQL Server™ sort order and character set.

Syntax

sp_helpsort

Return Code Values

0 (success) or 1 (failure)

Result Sets

None

Remarks

The default is case-insensitive dictionary sort order.

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 server running SQL Server.

Permissions

Execute permissions default to the public role.

Examples

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

  

See Also

Sort Order

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.