sp_helplanguage (Transact-SQL)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance
Reports information about a particular alternative language or about all languages in SQL Server.
Transact-SQL syntax conventions
Syntax
sp_helplanguage [ [ @language = ] N'language' ]
[ ; ]
Arguments
[ @language = ] N'language'
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 isn't specified, information about all languages in the sys.syslanguages
compatibility view is returned.
Return code values
0
(success) or 1
(failure).
Result set
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. |
Permissions
Requires membership in the public role.
Examples
A. Return information about a single language
The following example displays information about the alternative language French
.
EXEC sp_helplanguage French;
B. Return information about all languages
The following example displays information about all installed alternative languages.
EXEC sp_helplanguage;
Related content
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru