--- title: "@@LANGUAGE (Transact-SQL)" description: "@@LANGUAGE (Transact-SQL)" author: markingmyname ms.author: maghan ms.date: "09/18/2017" ms.prod: sql ms.technology: t-sql ms.topic: reference f1_keywords: - "@@LANGUAGE_TSQL" - "@@LANGUAGE" helpviewer_keywords: - "languages [SQL Server], current in use" - "@@LANGUAGE function" - "current language in use" - "names [SQL Server], language in use" dev_langs: - "TSQL" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current" --- # @@LANGUAGE (Transact-SQL) [!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)] Returns the name of the language currently being used. ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md) ## Syntax ```syntaxsql @@LANGUAGE ``` [!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)] ## 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. ```sql SELECT @@LANGUAGE AS 'Language Name'; ``` [!INCLUDE[ssResult](../../includes/ssresult-md.md)] ``` Language Name ------------------------------ us_english ``` ## See Also [Configuration Functions (Transact-SQL)](../../t-sql/functions/configuration-functions-transact-sql.md) [SET LANGUAGE (Transact-SQL)](../../t-sql/statements/set-language-transact-sql.md) [sp_helplanguage (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helplanguage-transact-sql.md)