sp_helplanguage (Transact-SQL)

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

Topic link icon Transact-SQL Syntax Conventions

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;

See Also

Reference

Database Engine Stored Procedures (Transact-SQL)

@@LANGUAGE (Transact-SQL)

SET LANGUAGE (Transact-SQL)

System Stored Procedures (Transact-SQL)