sp_helplanguage (Transact-SQL)
Reports information about a particular alternative language or about all languages.
Transact-SQL Syntax Conventions
- [ @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.
| 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 2005 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. |
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
