sp_helplanguage (Transact-SQL)


Reports information about a particular alternative language or about all languages in SQL Server 2016.

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.

Topic link icon Transact-SQL Syntax Conventions

sp_helplanguage [ [ @language = ] 'language' ]  

[ @language= ] 'language'
Is 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 is not specified, information about all languages in the sys.syslanguages compatibility view is returned.

0 (success) or 1 (failure)

Column nameData typeDescription
langidsmallintLanguage identification number.
dateformatnchar(3)Format of the date.
datefirsttinyintFirst day of the week: 1 for Monday, 2 for Tuesday, and so on through 7 for Sunday.
upgradeintSQL Server version of the last upgrade for this language.
namesysnameLanguage name.
aliassysnameAlternative name of the language.
monthsnvarchar(372)Month names.
shortmonthsnvarchar(132)Short month names.
daysnvarchar(217)Day names.
lcidintWindows locale ID for the language.
msglangidsmallintSQL Server message group ID.

Requires membership in the public role.

A. Returning information about a single language

The following example displays information about the alternative language French.

sp_helplanguage French;  

B. Returning information about all languages

The following example displays information about all installed alternative languages.


Database Engine Stored Procedures (Transact-SQL)
@@LANGUAGE (Transact-SQL)
System Stored Procedures (Transact-SQL)

Community Additions