Skip to content

sp-helplanguage-transact-sql.md

Latest commit

 

History

History
85 lines (67 loc) · 3.49 KB

sp-helplanguage-transact-sql.md

File metadata and controls

85 lines (67 loc) · 3.49 KB
title sp_helplanguage (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service database-engine, sql-database
ms.reviewer
ms.technology system-objects
ms.topic language-reference
f1_keywords
sp_helplanguage
sp_helplanguage_TSQL
dev_langs
TSQL
helpviewer_keywords
sp_helplanguage
default languages
ms.assetid 8c4651a5-7dbc-49c5-8691-dc72103c2dfa
author stevestein
ms.author sstein
monikerRange =azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sp_helplanguage (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

Reports information about a particular alternative language or about all languages in [!INCLUDEssCurrent].

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

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

Database Engine Stored Procedures (Transact-SQL)
@@LANGUAGE (Transact-SQL)
SET LANGUAGE (Transact-SQL)
System Stored Procedures (Transact-SQL)