| title | sp_helplanguage (Transact-SQL) | ||
|---|---|---|---|
| description | sp_helplanguage Reports information about a particular alternative language or about all languages in the SQL Server Database Engine. | ||
| author | markingmyname | ||
| ms.author | maghan | ||
| ms.reviewer | randolphwest | ||
| ms.date | 06/23/2025 | ||
| ms.service | sql | ||
| ms.subservice | system-objects | ||
| ms.topic | reference | ||
| ms.custom |
|
||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
||
| monikerRange | =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB]
Reports information about a particular alternative language or about all languages in [!INCLUDE ssnoversion-md].
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_helplanguage [ [ @language = ] N'language' ]
[ ; ]
The name of the alternative 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 isn't specified, information about all languages in the sys.syslanguages compatibility view 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 | [!INCLUDE ssNoVersion] version of the last upgrade for this language. |
name |
sysname | Language name. |
alias |
sysname | Alternative name of the language. |
months |
nvarchar(372) | Month names. |
shortmonths |
nvarchar(132) | Short month names. |
days |
nvarchar(217) | Day names. |
lcid |
int | Windows locale ID for the language. |
msglangid |
smallint | [!INCLUDE ssNoVersion] message group ID. |
Requires membership in the public role.
The following example displays information about the alternative language French.
EXECUTE sp_helplanguage French;The following example displays information about all installed alternative languages.
EXECUTE sp_helplanguage;