SQL @@LANGID

SQL @@LANGID Configuration Function will return the ID (local language identifier) of the language that is currently being used. Syntax behind this is

@@LANGID

SQL @@LANGID Example

Below code snippet will show you the language ID currently used by SQL.

SELECT @@LANGID AS 'Language ID Number'
SQL @@LANGID 1

As you know that the language ID of the US English (my default language) is 0. You can use the SET LANGUAGE statement to change the default language. For example, let me change the US English to Italian

SET LANGUAGE Italian

SELECT @@LANGID AS 'Language ID Number'
SQL @@LANGID 2

If you don’t know the list of available SQL Server languages and it’s IDs, then use sp_helplanguage system stored procedure.

SQL @@LANGID 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.