@@LANGUAGE (TSQL Function)

Returns the current language for the session.

Syntax

@@LANGUAGE

Return Types

Returns varchar.

Examples

SET LANGUAGE en_US;
PRINT 'current language is ' + @@LANGUAGE + ', @@DATEFIRST is ' + cast(@@DATEFIRST as varchar(100));

SET LANGUAGE fr_FR;
PRINT 'current language is ' + @@LANGUAGE + ', @@DATEFIRST is ' + cast(@@DATEFIRST as varchar(100));

The result is:

current language is en-US, @@DATEFIRST is 7
current language is fr-FR, @@DATEFIRST is 1