sp_helplanguage (Transact-SQL)

Article
02/28/2023

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.

Syntax

  
sp_helplanguage [ [ @language = ] 'language' ]

Arguments

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

Return Code Values

0 (success) or 1 (failure)

Result Sets

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

sp_helplanguage;