As we know, SQL Server supports multiple languages, so we can set any language for SQL Server. The sys.syslanguages system view contains all information about the languages supported by SQL Server.
You can use the below sql script to retrieve the information about all languages like language id,language name, dateformat and other info.
Query:
- SELECT name,* FROM sys.syslanguages
Example:

Join the conversation! Your thoughts help the community grow.