Returns the name of the language currently in use.
@@LANGUAGE
nvarchar
To view information about language settings (including valid official language names), run sp_helplanguage with no parameter specified.
This example returns the language for the current session.
SELECT @@LANGUAGE AS 'Language Name'
Here is the result set:
Language Name
-----------------------------
us_english
SET LANGUAGE | Configuration Functions |
sp_helplanguage |