.png)
sp_helplanguage (Transact-SQL)
Reports information about a particular alternative language or about all languages in SQL Server 2012.
|
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. |
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;
