Transact-SQL Reference
sp_helplanguage
Reports information about a particular alternate language or about all languages.
Syntax
sp_helplanguage [ [ @language = ] 'language' ]
Arguments
[@language =] 'language'
Is the name of the alternate language for which to display information. language is sysname, with a default of NULL. If language is specified, information about the specified language is returned. If language is not specified, information about all languages in the syslanguages system table is returned.
Return Code Values
0 (success) or 1 (failure)
Result Sets
| Column name | Data type | Description |
|---|---|---|
| langid | smallint | Language identification number. |
| dateformat | nchar(3) | Format of the date. |
| datefirst | tinyint | First day of the week: 1 for Monday, 2 for Tuesday, and so on through 7 for Sunday. |
| upgrade | int | Microsoft® SQL Server™ version of the last upgrade for this language. |
| name | sysname | Language name. |
| alias | sysname | Alternate name of the language. |
| months | nvarchar(372) | Month names. |
| shortmonths | nvarchar(132) | Short month names. |
| days | nvarchar(217) | Day names. |
| lcid | int | Microsoft Windows NT® locale ID for the language. |
| msglangid | smallint | SQL Server message group ID. |
Permissions
Execute permissions default to the public role.
Examples
A. Return information about a single language
This example displays information about the alternate language French.
sp_helplanguage french
B. Return information about all languages
This example displays information about all installed alternate languages.
sp_helplanguage