| title | sp_helplanguage (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql-non-specified | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 8c4651a5-7dbc-49c5-8691-dc72103c2dfa | ||
| caps.latest.revision | 19 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx_md]
Reports information about a particular alternative language or about all languages in [!INCLUDEssCurrent].
| Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version), [!INCLUDEssSDSfull]. |
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 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 | [!INCLUDEssNoVersion] 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 | [!INCLUDEssNoVersion] message group ID. |
Requires membership in the public role.
The following example displays information about the alternative language French.
sp_helplanguage French;
The following example displays information about all installed alternative languages.
sp_helplanguage;
Database Engine Stored Procedures (Transact-SQL)
@@LANGUAGE (Transact-SQL)
SET LANGUAGE (Transact-SQL)
System Stored Procedures (Transact-SQL)