sp_helpsort
Displays the Microsoft® SQL Server™ sort order and character set.
Syntax
sp_helpsort
Return Code Values
0 (success) or 1 (failure)
Result Sets
Returns server default collation.
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
This is the result set.
Server default collation
------------------------
Latin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 51 on Code Page 1252 for non-Unicode Data.
See Also
'
Comments (
)
)
Link to this page:
//www.vb-net.com/Sql/Sql/Ts_sp_help_2l4k.htm
|
|