SQL @@LANGID is one of the Configuration Function, which 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'
OUTPUT
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'
OUTPUT
If you don’t know the list of available SQL Server languages and it’s IDs, then use sp_helplanguage system stored procedure.
