sp_helplanguage (Transact-SQL)sp_helplanguage (Transact-SQL)

適用於: 是SQL Server (從 2008 開始) 是Azure SQL Database 否Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server (starting with 2008) yesAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

報告特定替代語言或 SQL Server 2017SQL Server 2017 中所有語言的相關資訊。Reports information about a particular alternative language or about all languages in SQL Server 2017SQL Server 2017.

主題連結圖示 Transact-SQL 語法慣例Topic link icon Transact-SQL Syntax Conventions

語法Syntax

  
sp_helplanguage [ [ @language = ] 'language' ]  

引數Arguments

[ @language = ] 'language' 是要顯示資訊的替代語言名稱。[ @language = ] 'language' Is the name of the alternative language for which to display information. 語言sysname,預設值是 NULL。language is sysname, with a default of NULL. 如果語言已指定,會傳回指定語言的相關資訊。If language is specified, information about the specified language is returned. 如果未指定語言,在 所有語言的相關資訊sys.syslanguages相容性檢視會傳回。If language is not specified, information about all languages in the sys.syslanguages compatibility view is returned.

傳回碼值Return Code Values

0 (成功) 或 1 (失敗)0 (success) or 1 (failure)

結果集Result Sets

資料行名稱Column name 資料類型Data type 描述Description
langidlangid smallintsmallint 語言識別碼。Language identification number.
dateformatdateformat nchar(3)nchar(3) 日期的格式。Format of the date.
datefirstdatefirst tinyinttinyint 每週第一天:1 代表星期一,2 代表星期二,依此類推,7 則代表星期日。First day of the week: 1 for Monday, 2 for Tuesday, and so on through 7 for Sunday.
upgradeupgrade intint 這個語言最後升級的 SQL ServerSQL Server 版本。SQL ServerSQL Server version of the last upgrade for this language.
namename sysnamesysname 語言名稱。Language name.
aliasalias sysnamesysname 語言的替代名稱。Alternative name of the language.
幾個月months nvarchar(372)nvarchar(372) 月份名稱。Month names.
shortmonthsshortmonths nvarchar(132)nvarchar(132) 簡短月份名稱。Short month names.
daysdays nvarchar(217)nvarchar(217) 日期名稱。Day names.
lcidlcid intint 語言的 Windows 地區設定識別碼。Windows locale ID for the language.
msglangidmsglangid smallintsmallint SQL ServerSQL Server 訊息群組識別碼。message group ID.

PermissionsPermissions

需要 public 角色的成員資格。Requires membership in the public role.

範例Examples

A.A. 傳回單一語言的相關資訊Returning information about a single language

下列範例會顯示替代語言 French 的相關資訊。The following example displays information about the alternative language French.

sp_helplanguage French;  

B.B. 傳回所有語言的相關資訊Returning information about all languages

下列範例會顯示所有已安裝之替代語言的相關資訊。The following example displays information about all installed alternative languages.

sp_helplanguage;  

另請參閱See Also

Database Engine 預存程序(Transact SQL) Database Engine Stored Procedures (Transact-SQL)
@@LANGUAGE (Transact-SQL) @@LANGUAGE (Transact-SQL)
SET LANGUAGE (Transact-SQL) SET LANGUAGE (Transact-SQL)
系統預存程序 (Transact-SQL)System Stored Procedures (Transact-SQL)