Export (0) Print
Expand All
Expand Minimize

sp_helplanguage

SQL Server 2000

Reports information about a particular alternate language or about all languages.

Syntax

sp_helplanguage [ [ @language = ] 'language' ]

Arguments

[@language =] 'language'

Is the name of the alternate 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 syslanguages system table 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 Microsoft® SQL Server™ version of the last upgrade for this language.
name sysname Language name.
alias sysname Alternate name of the language.
months nvarchar(372) Month names.
shortmonths nvarchar(132) Short month names.
days nvarchar(217) Day names.
lcid int Microsoft Windows NT® locale ID for the language.
msglangid smallint SQL Server message group ID.

Permissions

Execute permissions default to the public role.

Examples
A. Return information about a single language

This example displays information about the alternate language French.

sp_helplanguage french
B. Return information about all languages

This example displays information about all installed alternate languages.

sp_helplanguage

See Also

@@LANGUAGE

SET LANGUAGE

System Stored Procedures

Show:
© 2014 Microsoft