| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_helplanguage (Transact-SQL) |
sp_helplanguage Reports information about a particular alternative language or about all languages in the SQL Server Database Engine. |
markingmyname |
maghan |
randolphwest |
05/15/2024 |
sql |
system-objects |
reference |
|
|
|
=azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]
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.
EXEC sp_helplanguage French;The following example displays information about all installed alternative languages.
EXEC sp_helplanguage;