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