Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Reports information about a particular alternative language or about all languages in SQL Server.
Transact-SQL syntax conventions
Syntax
sp_helplanguage [ [ @language = ] N'language' ]
[ ; ]
Arguments
[ @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.
Return code values
0 (success) or 1 (failure).
Result set
| 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 | SQL Server 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 | SQL Server message group ID. |
Permissions
Requires membership in the public role.
Examples
A. Return information about a single language
The following example displays information about the alternative language French.
EXECUTE sp_helplanguage French;
B. Return information about all languages
The following example displays information about all installed alternative languages.
EXECUTE sp_helplanguage;