SET LANGUAGE#
Specifies the language environment for the session. The session language determines the datetime formats and system messages.
The only supported setting is us_english. Any other setting will throw an error.
Syntax#
SET LANGUAGE { [ N ] 'language' | @language_var } [;]
Arguments#
[N]’language’ | @language_var
Is the name of the language as stored in sys.syslanguages. This argument can be either Unicode or DBCS converted to Unicode. To specify a language in Unicode, use N’language’. If specified as a variable, the variable must be sysname.
Remarks#
Argument values are ignored and do not change the default behavior.
Permissions#
Requires membership in the public role.
Examples#
The following example sets the language us_english.
SET LANGUAGE us_english;