@@LANGUAGE (Transact-SQL)
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
Returns the name of the language currently being used.
Transact-SQL syntax conventions
Syntax
@@LANGUAGE
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
Return Types
nvarchar
Remarks
To view information about language settings, including valid official language names, run sp_helplanguage without a parameter specified.
Examples
The following example returns the language for the current session.
SELECT @@LANGUAGE AS 'Language Name';
Here is the result set.
Language Name
------------------------------
us_english
See Also
Configuration Functions (Transact-SQL)
SET LANGUAGE (Transact-SQL)
sp_helplanguage (Transact-SQL)