در این پست کوتاه لیست تمامی زبان های نصب شده در SQL Server 2017 database engine را مشاهده خواهید کرد. هم زبان های نصب شده و فرمت های تاریخ مربوط به آن زبان و همچنین روز شروع هفته در آن زبان را هم مشاهده خواهید کرد.


برای دسترسی به این لیست می توانید از Stored Procedure سیستمی sp_helplanguage و یا View سیستمی sys.syslanguages استفاده کنید. لیست زیر شامل نام ستون ها و مقادیر مربوط به آنها برای هر زبان است.

exec sp_helplanguage

یا

SELECT * FROM sys.syslanguages

English
langid	0

dateformat	mdy

datefirst	7

upgrade	0

name	us_english

alias	English

months	January, February, March, April, May, June, July, August, September, October, November, December

shortmonths	Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec

days	Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday

lcid	1033

msglangid	1033

German
langid	1

dateformat	dmy

datefirst	1

upgrade	0

name	Deutsch

alias	German

months	Januar, Februar, März, April, Mai, Juni, Juli, August, September, Oktober, November, Dezember

shortmonths	Jan, Feb, Mär, Apr, Mai, Jun, Jul, Aug, Sep, Okt, Nov, Dez

days	Montag, Dienstag, Mittwoch, Donnerstag, Freitag, Samstag, Sonntag

lcid	1031

msglangid	1031

French
langid	2

dateformat	dmy

datefirst	1

upgrade	0

name	Français

alias	French

months	janvier, février, mars, avril, mai, juin, juillet, août, septembre, octobre, novembre, décembre

shortmonths	janv, févr, mars, avr, mai, juin, juil, août, sept, oct, nov, déc

days	lundi, mardi, mercredi, jeudi, vendredi, samedi, dimanche

lcid	1036

msglangid	1036

Japanese
langid	3

dateformat	ymd

datefirst	7

upgrade	0

name	日本語

alias	Japanese

months	01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12

shortmonths	01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12

days	月曜日, 火曜日, 水曜日, 木曜日, 金曜日, 土曜日, 日曜日

lcid	1041

msglangid	1041

Danish
langid	4

dateformat	dmy

datefirst	1

upgrade	0

name	Dansk

alias	Danish

months	januar, februar, marts, april, maj, juni, juli, august, september, oktober, november, december

shortmonths	jan, feb, mar, apr, maj, jun, jul, aug, sep, okt, nov, dec

days	mandag, tirsdag, onsdag, torsdag, fredag, lørdag, søndag

lcid	1030

msglangid	1030

Spanish
langid	5

dateformat	dmy

datefirst	1

upgrade	0

name	Español

alias	Spanish

months	Enero, Febrero, Marzo, Abril, Mayo, Junio, Julio, Agosto, Septiembre, Octubre, Noviembre, Diciembre

shortmonths	Ene, Feb, Mar, Abr, May, Jun, Jul, Ago, Sep, Oct, Nov, Dic

days	Lunes, Martes, Miércoles, Jueves, Viernes, Sábado, Domingo

lcid	3082

msglangid	3082

Italian
langid	6

dateformat	dmy

datefirst	1

upgrade	0

name	Italiano

alias	Italian

months	gennaio, febbraio, marzo, aprile, maggio, giugno, luglio, agosto, settembre, ottobre, novembre, dicembre

shortmonths	gen, feb, mar, apr, mag, giu, lug, ago, set, ott, nov, dic

days	lunedì, martedì, mercoledì, giovedì, venerdì, sabato, domenica

lcid	1040

msglangid	1040

Dutch
langid	7

dateformat	dmy

datefirst	1

upgrade	0

name	Nederlands

alias	Dutch

months	januari, februari, maart, april, mei, juni, juli, augustus, september, oktober, november, december

shortmonths	jan, feb, mrt, apr, mei, jun, jul, aug, sep, okt, nov, dec

days	maandag, dinsdag, woensdag, donderdag, vrijdag, zaterdag, zondag

lcid	1043

msglangid	1043

Norwegian
langid	8

dateformat	dmy

datefirst	1

upgrade	0

name	Norsk

alias	Norwegian

months	januar, februar, mars, april, mai, juni, juli, august, september, oktober, november, desember

shortmonths	jan, feb, mar, apr, mai, jun, jul, aug, sep, okt, nov, des

days	mandag, tirsdag, onsdag, torsdag, fredag, lørdag, søndag

lcid	2068

msglangid	2068

Portuguese
langid	9

dateformat	dmy

datefirst	7

upgrade	0

name	Português

alias	Portuguese

months	janeiro, fevereiro, março, abril, maio, junho, julho, agosto, setembro, outubro, novembro, dezembro

shortmonths	jan, fev, mar, abr, mai, jun, jul, ago, set, out, nov, dez

days	segunda-feira, terça-feira, quarta-feira, quinta-feira, sexta-feira, sábado, domingo

lcid	2070

msglangid	2070

Finnish
langid	10

dateformat	dmy

datefirst	1

upgrade	0

name	Suomi

alias	Finnish

months	tammikuuta, helmikuuta, maaliskuuta, huhtikuuta, toukokuuta, kesäkuuta, heinäkuuta, elokuuta, syyskuuta, lokakuuta, marraskuuta, joulukuuta

shortmonths	tammi, helmi, maalis, huhti, touko, kesä, heinä, elo, syys, loka, marras, joulu

days	maanantai, tiistai, keskiviikko, torstai, perjantai, lauantai, sunnuntai

lcid	1035

msglangid	1035

Swedish
langid	11

dateformat	ymd

datefirst	1

upgrade	0

name	Svenska

alias	Swedish

months	januari, februari, mars, april, maj, juni, juli, augusti, september, oktober, november, december

shortmonths	jan, feb, mar, apr, maj, jun, jul, aug, sep, okt, nov, dec

days	måndag, tisdag, onsdag, torsdag, fredag, lördag, söndag

lcid	1053

msglangid	1053

Czech
langid	12

dateformat	dmy

datefirst	1

upgrade	0

name	čeština

alias	Czech

months	leden, únor, březen, duben, květen, červen, červenec, srpen, září, říjen, listopad, prosinec

shortmonths	I, II, III, IV, V, VI, VII, VIII, IX, X, XI, XII

days	pondělí, úterý, středa, čtvrtek, pátek, sobota, neděle

lcid	1029

msglangid	1029

Hungarian
langid	13

dateformat	ymd

datefirst	1

upgrade	0

name	magyar

alias	Hungarian

months	január, február, március, április, május, június, július, augusztus, szeptember, október, november, december

shortmonths	jan, febr, márc, ápr, máj, jún, júl, aug, szept, okt, nov, dec

days	hétfő, kedd, szerda, csütörtök, péntek, szombat, vasárnap

lcid	1038

msglangid	1038

Polish
langid	14

dateformat	dmy

datefirst	1

upgrade	0

name	polski

alias	Polish

months	styczeń, luty, marzec, kwiecień, maj, czerwiec, lipiec, sierpień, wrzesień, październik, listopad, grudzień

shortmonths	I, II, III, IV, V, VI, VII, VIII, IX, X, XI, XII

days	poniedziałek, wtorek, środa, czwartek, piątek, sobota, niedziela

lcid	1045

msglangid	1045

Romanian
langid	15

dateformat	dmy

datefirst	1

upgrade	0

name	română

alias	Romanian

months	ianuarie, februarie, martie, aprilie, mai, iunie, iulie, august, septembrie, octombrie, noiembrie, decembrie

shortmonths	Ian, Feb, Mar, Apr, Mai, Iun, Iul, Aug, Sep, Oct, Nov, Dec

days	luni, marţi, miercuri, joi, vineri, sîmbătă, duminică

lcid	1048

msglangid	1048

Croatian
langid	16

dateformat	ymd

datefirst	1

upgrade	0

name	hrvatski

alias	Croatian

months	siječanj, veljača, ožujak, travanj, svibanj, lipanj, srpanj, kolovoz, rujan, listopad, studeni, prosinac

shortmonths	sij, vel, ožu, tra, svi, lip, srp, kol, ruj, lis, stu, pro

days	ponedjeljak, utorak, srijeda, četvrtak, petak, subota, nedjelja

lcid	1050

msglangid	1050

Slovak
langid	17

dateformat	dmy

datefirst	1

upgrade	0

name	slovenčina

alias	Slovak

months	január, február, marec, apríl, máj, jún, júl, august, september, október, november, december

shortmonths	I, II, III, IV, V, VI, VII, VIII, IX, X, XI, XII

days	pondelok, utorok, streda, štvrtok, piatok, sobota, nedeľa

lcid	1051

msglangid	1051

Slovenian
langid	18

dateformat	dmy

datefirst	1

upgrade	0

name	slovenski

alias	Slovenian

months	januar, februar, marec, april, maj, junij, julij, avgust, september, oktober, november, december

shortmonths	jan, feb, mar, apr, maj, jun, jul, avg, sept, okt, nov, dec

days	ponedeljek, torek, sreda, četrtek, petek, sobota, nedelja

lcid	1060

msglangid	1060

Greek
langid	19

dateformat	dmy

datefirst	1

upgrade	0

name	ελληνικά

alias	Greek

months	Ιανουαρίου, Φεβρουαρίου, Μαρτίου, Απριλίου, Μα_ου, Ιουνίου, Ιουλίου, Αυγούστου, Σεπτεμβρίου, Οκτωβρίου, Νοεμβρίου, Δεκεμβρίου

shortmonths	Ιαν, Φεβ, Μαρ, Απρ, Μαϊ, Ιουν, Ιουλ, Αυγ, Σεπ, Οκτ, Νοε, Δεκ

days	Δευτέρα, Τρίτη, Τετάρτη, Πέμπτη, Παρασκευή, Σάββατο, Κυριακή

lcid	1032

msglangid	1032

Bulgarian
langid	20

dateformat	dmy

datefirst	1

upgrade	0

name	български

alias	Bulgarian

months	януари, февруари, март, април, май, юни, юли, август, септември, октомври, ноември, декември

shortmonths	януари, февруари, март, април, май, юни, юли, август, септември, октомври, ноември, декември

days	понеделник, вторник, сряда, четвъртък, петък, събота, неделя

lcid	1026

msglangid	1026

Russian
langid	21

dateformat	dmy

datefirst	1

upgrade	0

name	русский

alias	Russian

months	Январь, Февраль, Март, Апрель, Май, Июнь, Июль, Август, Сентябрь, Октябрь, Ноябрь, Декабрь

shortmonths	янв, фев, мар, апр, май, июн, июл, авг, сен, окт, ноя, дек

days	понедельник, вторник, среда, четверг, пятница, суббота, воскресенье

lcid	1049

msglangid	1049

Turkish
langid	22

dateformat	dmy

datefirst	1

upgrade	0

name	Türkçe

alias	Turkish

months	Ocak, Şubat, Mart, Nisan, Mayıs, Haziran, Temmuz, Ağustos, Eylül, Ekim, Kasım, Aralık

shortmonths	Oca, Şub, Mar, Nis, May, Haz, Tem, Ağu, Eyl, Eki, Kas, Ara

days	Pazartesi, Salı, Çarşamba, Perşembe, Cuma, Cumartesi, Pazar

lcid	1055

msglangid	1055

British English
langid	23

dateformat	dmy

datefirst	1

upgrade	0

name	British

alias	British English

months	January, February, March, April, May, June, July, August, September, October, November, December

shortmonths	Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec

days	Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday

lcid	2057

msglangid	1033

Estonian
langid	24

dateformat	dmy

datefirst	1

upgrade	0

name	eesti

alias	Estonian

months	jaanuar, veebruar, märts, aprill, mai, juuni, juuli, august, september, oktoober, november, detsember

shortmonths	jaan, veebr, märts, apr, mai, juuni, juuli, aug, sept, okt, nov, dets

days	esmaspäev, teisipäev, kolmapäev, neljapäev, reede, laupäev, pühapäev

lcid	1061

msglangid	1061

Latvian
langid	25

dateformat	ymd

datefirst	1

upgrade	0

name	latviešu

alias	Latvian

months	janvāris, februāris, marts, aprīlis, maijs, jūnijs, jūlijs, augusts, septembris, oktobris, novembris, decembris

shortmonths	jan, feb, mar, apr, mai, jūn, jūl, aug, sep, okt, nov, dec

days	pirmdiena, otrdiena, trešdiena, ceturtdiena, piektdiena, sestdiena, svētdiena

lcid	1062

msglangid	1062

Lithuanian
langid	26

dateformat	ymd

datefirst	1

upgrade	0

name	lietuvių

alias	Lithuanian

months	sausis, vasaris, kovas, balandis, gegužė, birželis, liepa, rugpjūtis, rugsėjis, spalis, lapkritis, gruodis

shortmonths	sau, vas, kov, bal, geg, bir, lie, rgp, rgs, spl, lap, grd

days	pirmadienis, antradienis, trečiadienis, ketvirtadienis, penktadienis, šeštadienis, sekmadienis

lcid	1063

msglangid	1063

Brazilian
langid	27

dateformat	dmy

datefirst	7

upgrade	0

name	Português (Brasil)

alias	Brazilian

months	Janeiro, Fevereiro, Março, Abril, Maio, Junho, Julho, Agosto, Setembro, Outubro, Novembro, Dezembro

shortmonths	Jan, Fev, Mar, Abr, Mai, Jun, Jul, Ago, Set, Out, Nov, Dez

days	Segunda-Feira, Terça-Feira, Quarta-Feira, Quinta-Feira, Sexta-Feira, Sábado, Domingo

lcid	1046

msglangid	1046

Traditional Chinese
langid	28

dateformat	ymd

datefirst	7

upgrade	0

name	繁體中文

alias	Traditional Chinese

months	一月, 二月, 三月, 四月, 五月, 六月, 七月, 八月, 九月, 十月, 十一月, 十二月

shortmonths	01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12

days	星期一, 星期二, 星期三, 星期四, 星期五, 星期六, 星期日

lcid	1028

msglangid	1028

Korean
langid	29

dateformat	ymd

datefirst	7

upgrade	0

name	한국어

alias	Korean

months	01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12

shortmonths	01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12

days	월요일, 화요일, 수요일, 목요일, 금요일, 토요일, 일요일

lcid	1042

msglangid	1042

Simplified Chinese
langid	30

dateformat	ymd

datefirst	7

upgrade	0

name	简体中文

alias	Simplified Chinese

months	01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12

shortmonths	01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12

days	星期一, 星期二, 星期三, 星期四, 星期五, 星期六, 星期日

lcid	2052

msglangid	2052

Arabic
langid	31

dateformat	dmy

datefirst	1

upgrade	0

name	Arabic

alias	Arabic

months	Muharram, Safar, Rabie I, Rabie II, Jumada I, Jumada II, Rajab, Shaaban, Ramadan, Shawwal, Thou Alqadah, Thou Alhajja

shortmonths	Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec

days	Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday

lcid	1025

msglangid	1025

Thai
langid	32

dateformat	dmy

datefirst	7

upgrade	0

name	ไทย

alias	Thai

months	มกราคม, กุมภาพันธ์, มีนาคม, เมษายน, พฤษภาคม, มิถุนายน, กรกฎาคม, สิงหาคม, กันยายน, ตุลาคม, พฤศจิกายน, ธันวาคม

shortmonths	ม.ค., ก.พ., มี.ค., เม.ย., พ.ค., มิ.ย., ก.ค., ส.ค., ก.ย., ต.ค., พ.ย., ธ.ค.

days	จันทร์, อังคาร, พุธ, พฤหัสบดี, ศุกร์, เสาร์, อาทิตย์

lcid	1054

msglangid	1054

Bokmål

langid	33

dateformat	dmy

datefirst	1

upgrade	0

name	norsk (bokmål)

alias	Bokmål

months	januar, februar, mars, april, mai, juni, juli, august, september, oktober, november, desember

shortmonths	jan, feb, mar, apr, mai, jun, jul, aug, sep, okt, nov, des

days	mandag, tirsdag, onsdag, torsdag, fredag, lørdag, søndag

lcid	1044

msglangid	1044