SQL @@LANGUAGE

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

@@LANGUAGE

SQL @@LANGUAGE Example

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

SELECT @@LANGUAGE AS 'Language Name'
SELECT @@LANGUAGE

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'
Set LANGUAGE French 2

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

SQL @@LANGUAGE 3

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.