sp_helplanguage (Transact-SQL)

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


sp_helplanguage [ [ @language = ] N'language' ]
[ ; ]


[ @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.


Requires membership in the public role.


A. Return information about a single language

The following example displays information about the alternative language French.

EXEC sp_helplanguage French;

B. Return information about all languages

The following example displays information about all installed alternative languages.

EXEC sp_helplanguage;