SQL @@Language Function

SQL Server @@Language is a configuration function that returns the name of the language currently being used.





SYNTAX

@@LANGUAGE

Return Type of @@LANGUAGE is nvarchar.

Lets look at an example showing functionality of @@Language function in SQL Server.

Following statement uses @@language function and returns the language name that is currently being used by SQL Server.

SELECT @@LANGUAGE AS 'Language Name';

As you can see, it returns current language ‘us_english’.

You can also change the default language for SQL Server using SET language function.

Lets change the SQL Server Current Language from US English to Spanish.

SET LANGUAGE Spanish;

SELECT @@LANGUAGE AS 'Language Name'

 

 

You can also see the list of valid official languages supported by SQL Server, using stored procedure  sp_helplanguage.

 

 EXEC sp_helplanguage;

 

As you can see, it returns the detailed information about all languages supported by SQL Server.

 

 

Also Read..

SQL SET language function

SQL Server @@version

SQL Server @@SPID



SQL Basics TutorialSQL Advance TutorialSSRSInterview Q & A
SQL Create tableSQL Server Stored ProcedureCreate a New SSRS Project List Of SQL Server basics to Advance Level Interview Q & A
SQL ALTER TABLESQL Server MergeCreate a Shared Data Source in SSRSSQL Server Question & Answer Quiz
SQL DropSQL Server PivotCreate a SSRS Tabular Report / Detail Report
..... More.... More....More
Power BI TutorialAzure TutorialPython TutorialSQL Server Tips & Tricks
Download and Install Power BI DesktopCreate an Azure storage accountLearn Python & ML Step by stepEnable Dark theme in SQL Server Management studio
Connect Power BI to SQL ServerUpload files to Azure storage containerSQL Server Template Explorer
Create Report ToolTip Pages in Power BICreate Azure SQL Database ServerDisplaying line numbers in Query Editor Window
....More....More....More

 195 total views,  3 views today

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.