Search notes:

SQL Server: set language

set language sets the session language.

set nocount on

set    language english
--     Changed language setting to us_english.

select datename(dw, '2019-04-05')
--     Friday

set    language german
--     Die Spracheneinstellung wurde in Deutsch geändert.

select datename(dw, '2019-04-05')
--     Freitag

Github repository about-MSSQL, path: /t-sql/statements/set/language/basic.sql

The currently set language is stored in @@language.

The chosen language apparently influences how a string is interpreted if cast to a datetime.

TODO

select * from sys.syslanguages;

SQL Server: set language

TODO

See also