Saturday , September 23 2023

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


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.


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.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *