sys.sp_helplanguage

Description

Reports information about a particular alternative language or about all languages in SQL The name of the alternative language for which to display information. is specified, information about the specified language is returned. If language isn’t specified, information about all languages in the compatibility view is returned. Language identification number.

Syntax

sp_helplanguage [ [ @language = ]
N
'language'
]
[ ; ]

Examples

Example 1

Italian

Example 2

@@LANGID

Example 3

@@
LANGID

Example 4

SET
LANGUAGE
'Italian'
SELECT
@@LANGID
AS
'Language ID'

Example 5

Changed language setting to Italiano.
Language ID
-----------
6

Example 6

@@
LANGUAGE

Example 7

SELECT
@@
LANGUAGE
AS
'Language Name'
;
Language Name
------------------------------

Example 8

us_english