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;

See also

The T-SQL set statement

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759331373, '216.73.216.88', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/SQL-Server/T-SQL/statements/set/language(63): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78