SET LANGUAGE and @@LANGUAGE Function in SQL Server(TSQL)

dbtut

5 years ago

We can set a session’s language With SET LANGUAGE Command. This command affects the system datetime format and system messages.

If you want to learn the session’s language, you can do this with @@LANGUAGE function.

Example:

We set the language as English, then we get the language name and current month name in the First Part.

We repeat the same process for French in the Second Part.

Finally we get the information about all languages with sys.syslanguages.

--First Part
SET LANGUAGE us_english;
GO
SELECT @@LANGUAGE AS 'Language Name';
GO
SELECT DATENAME(month, GETDATE()) AS 'Month Name';
GO
--Second Part
SET LANGUAGE Français;
GO
SELECT @@LANGUAGE AS 'Language Name';
GO
SELECT DATENAME(month, GETDATE()) AS 'Month Name';
GO
--You can learn all language informations as follows.
SELECT * from sys.syslanguages

--First Part

SET LANGUAGE us_english;

SELECT @@LANGUAGE AS 'Language Name';

SELECT DATENAME(month, GETDATE()) AS 'Month Name';

--Second Part

SET LANGUAGE Français;

SELECT @@LANGUAGE AS 'Language Name';

SELECT DATENAME(month, GETDATE()) AS 'Month Name';

--You can learn all language informations as follows.

SELECT * from sys.syslanguages