--- description: "@@LANGUAGE (Transact-SQL)" title: "@@LANGUAGE (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "09/18/2017" ms.prod: sql ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw" ms.reviewer: "" ms.technology: t-sql ms.topic: reference f1_keywords: - "@@LANGUAGE_TSQL" - "@@LANGUAGE" dev_langs: - "TSQL" helpviewer_keywords: - "languages [SQL Server], current in use" - "@@LANGUAGE function" - "current language in use" - "names [SQL Server], language in use" ms.assetid: 3e13b477-7dfa-4da6-9948-da2050d42527 author: cawrites ms.author: chadam 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)