Reports information about a particular alternate language or about all languages.
sp_helplanguage [[@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.
0 (success) or 1 (failure)
| 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. |
Execute permissions default to the public role.
This example displays information about the alternate language French.
sp_helplanguage french
This example displays information about all installed alternate languages.
sp_helplanguage
| @@LANGUAGE | System Stored Procedures |
| SET LANGUAGE |