sys.syslanguages (Transact-SQL)sys.syslanguages (Transact-SQL)

適用於: 是SQL Server 是Azure SQL Database 是Azure SQL 資料倉儲 是平行處理資料倉儲 APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

針對 SQL ServerSQL Server 執行個體中的每種語言,各包含一個資料列。Contains one row for each language present in the instance of SQL ServerSQL Server.

資料行名稱Column name 資料類型Data type 描述Description
langidlangid smallintsmallint 唯一語言識別碼。Unique language ID.
dateformatdateformat nchar(3)nchar(3) 日期的順序,例如 DMY。Date order, for example, DMY.
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 保留供系統使用。Reserved for system use.
namename sysnamesysname 官方語言名稱,例如 Français。Official language name, for example, Français.
aliasalias sysnamesysname 替代語言名稱,例如 French。Alternative language name, for example, French.
monthsmonths nvarchar(372)nvarchar(372) 以逗號分隔的清單,依一月至十二月的順序列出完整長度的月份名稱,每個名稱最多可有 20 個字元。Comma-separated list of full-length month names in order from January through December, with each name having up to 20 characters.
shortmonthsshortmonths nvarchar(132)nvarchar(132) 以逗號分隔的清單,依一月至十二月的順序列出簡短的月份名稱,每個名稱最多可有 9 個字元。Comma-separated list of short-month names in order from January through December, with each name having up to 9 characters.
daysdays nvarchar(217)nvarchar(217) 以逗號分隔的清單,依星期一至星期日的順序列出各日的名稱,每個名稱最多可有 30 個字元。Comma-separated list of day names in order from Monday through Sunday, with each name having up to 30 characters.
lcidlcid intint MicrosoftMicrosoft 語言的 Windows 地區設定識別碼Windows locale ID for the language.
msglangidmsglangid smallintsmallint Database EngineDatabase Engine 訊息群組識別碼。message group ID.

Database EngineDatabase Engine 包含下列已安裝的語言。The Database EngineDatabase Engine contains the following installed languages.

英文名稱Name in English Windows LCIDWindows LCID Database EngineDatabase Engine 訊息群組識別碼message group ID
英文English 10331033 10331033
德文German 10311031 10311031
法文French 10361036 10361036
日文Japanese 10411041 10411041
丹麥文Danish 10301030 10301030
西班牙文Spanish 30823082 30823082
義大利文Italian 10401040 10401040
荷蘭文Dutch 10431043 10431043
挪威文Norwegian 20682068 20682068
葡萄牙文Portuguese 20702070 20702070
芬蘭文Finnish 10351035 10351035
瑞典文Swedish 10531053 10531053
捷克文Czech 10291029 10291029
匈牙利文Hungarian 10381038 10381038
波蘭文Polish 10451045 10451045
羅馬尼亞文Romanian 10481048 10481048
克羅埃西亞文Croatian 10501050 10501050
斯洛伐克文Slovak 10511051 10511051
斯洛維尼亞文Slovene 10601060 10601060
希臘文Greek 10321032 10321032
保加利亞文Bulgarian 10261026 10261026
俄文Russian 10491049 10491049
土耳其文Turkish 10551055 10551055
英式英文British English 20572057 10331033
愛沙尼亞文Estonian 10611061 10611061
拉脫維亞文Latvian 10621062 10621062
立陶宛文Lithuanian 10631063 10631063
葡萄牙文 (巴西)Portuguese (Brazil) 10461046 10461046
繁體中文Traditional Chinese 10281028 10281028
韓文Korean 10421042 10421042
簡體中文Simplified Chinese 20522052 20522052
阿拉伯文Arabic 10251025 10251025
泰文Thai 10541054 10541054

另請參閱See Also

相容性檢視(Transact SQL) Compatibility Views (Transact-SQL)
將系統資料表對應至 System (Views transact-sql)Mapping System Tables to System Views (Transact-SQL)