Transact-SQL Reference
@@LANGID
Returns the local language identifier (ID) of the language currently in use.
Syntax
@@LANGID
Return Types
smallint
Remarks
To view information about language settings (including language ID numbers), run sp_helplanguage with no parameter specified.
Examples
This example sets the language for the current session to Italian, and then uses @@LANGID to return the ID for Italian.
SET LANGUAGE 'Italian'
SELECT @@LANGID AS 'Language ID'
Here is the result set:
Language ID
--------------------
6