SQL @@LANGUAGE

SQL @@LANGUAGE is one of the Configuration Function, which will return the name of the language that is currently used. And the syntax behind this is

@@LANGUAGE

SQL @@LANGUAGE Example

Below code snippet will show you the language name that is currently being used by SQL.

SELECT @@LANGUAGE AS 'Language Name'
SQL @@LANGUAGE 1

You can use the SET LANGUAGE statement to change the default language. For example, let me change the US English to French

SET LANGUAGE French;

SELECT @@LANGUAGE AS 'Language Name'
SQL @@LANGUAGE 2

If you don’t know the list of available languages or their names, then use sp_helplanguage system stored procedure in SQL Server.

SQL @@LANGUAGE 3