Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the local language identifier (ID) of the language that is currently being used.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
@@LANGID
Return Types
smallint
Remarks
To view information about language settings, including language ID numbers, run sp_helplanguage without a parameter specified.
Examples
The following 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.
Changed language setting to Italiano.
Language ID
-----------
6
See Also
Reference
Configuration Functions (Transact-SQL)
SET LANGUAGE (Transact-SQL)
sp_helplanguage (Transact-SQL)