@@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)