SQL @@LANGUAGE is one of the Configuration Function, which will return the name of the language that is currently being used. And the syntax behind this is
|
1 |
@@LANGUAGE |
SQL @@LANGUAGE Example
Below code snippet will show you the language name that is currently being used by SQL.
|
1 |
SELECT @@LANGUAGE AS 'Language Name' |
OUTPUT
You can use the SET LANGUAGE statement to change the default language. For example, let me change the US English to French
|
1 2 3 |
SET LANGUAGE French; SELECT @@LANGUAGE AS 'Language Name' |
OUTPUT
If you don’t know the list of available languages, or their names then use sp_helplanguage system stored procedure.
Thank You for Visiting Our Blog
Share your Feedback, or Code!!