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

See Also