Tutorial Gateway

  • C Language
  • Java
  • R
  • SQL
  • MySQL
  • Python
  • BI Tools
    • Informatica
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • QlikView
  • Js

SQL @@LANGID

by suresh

SQL @@LANGID is one of the Configuration Function, which will return the ID (local language identifier) of the language that is currently being used. Syntax behind this is

@@LANGID

SQL @@LANGID Example

Below code snippet will show you the language ID that is currently being used by SQL.

SELECT @@LANGID AS 'Language ID Number'

OUTPUT

SQL @@LANGID 1

As you know that the language ID of the US English (my default language) is 0. You can use the SET LANGUAGE statement to change the default language. For example, let me change the US English to Italian

SET LANGUAGE Italian

SELECT @@LANGID AS 'Language ID Number'

 OUTPUT

SQL @@LANGID 2

If you don’t know the list of available languages, and it’s IDs then use sp_helplanguage system stored procedure.

SQL @@LANGID 3

Thank You for Visiting Our Blog

Placed Under: SQL

Stay in Touch!

Sign Up to receive Email updates on Latest Tutorials

  • C Programs
  • Java Programs
  • SQL FAQ’s
  • Python Programs
  • SSIS
  • Tableau
  • JavaScript

Copyright © 2019 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy