@@LANGID (T-SQL)

Returns the local language 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 Italiano, and then uses @@LANGID to return the ID for Italiano.

SET LANGUAGE 'Italiano'

SELECT @@LANGID AS 'Language ID'

Here is the result set:

Language ID

--------------------

6

See Also