Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
In this article
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
@@LANGUAGE
nvarchar
To view information about language settings, including valid official language names, run sp_helplanguage without a parameter specified.
The following example returns the language for the current session.
SELECT @@LANGUAGE AS 'Language Name';
Here's the result set.
Language Name
------------------------------
us_english
Configuration Functions (Transact-SQL)
SET LANGUAGE (Transact-SQL)
sp_helplanguage (Transact-SQL)