Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Quick Tip: How to Find SQL Server's Current Language

DZone's Guide to

Quick Tip: How to Find SQL Server's Current Language

Need to find out what SQL Server's default language is set to? These two quick tips will show you how to find out.

· Database Zone
Free Resource

Learn how our document data model can map directly to how you program your app, and native database features like secondary indexes, geospatial and text search give you full access to your data. Brought to you in partnership with MongoDB.

In this post, I will show the SQL Query to find SQL Server's Current Language. Write the following Query in the SQL Server and execute.

QUERY I to Find the Current Language of SQL Server

Select @@LANGUAGE as Language

Execute the preceding query and check the output.

SQL Query to Find Current Language of SQL Server

QUERY II to Find the Current Language of SQL Server:

Another way we can find the current language of SQL Server is by executing the following script:

select * from sys.syslanguages where langid=@@langid

Execute the preceding query and check the output.

SQL Query to Find Current Language of SQL Server

Using this query we can get the current language of SQL Server. I hope this trick is useful to developers.

Discover when your data grows or your application performance demands increase, MongoDB Atlas allows you to scale out your deployment with an automated sharding process that ensures zero application downtime. Brought to you in partnership with MongoDB.

Topics:
sql server 2014

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}