Как перевести sql на русский
Перейти к содержимому

Как перевести sql на русский

  • автор:


Как перевести sql на русский

Изменить С русского НА английский.

Точнее — как добавить новый язык?

Студия с русским интерфейсом установилась вместе с сервером. Язык ОС тоже русский.

Соответственно в окне "Параметры" (Среда\Выбор языка) у меня выбор либо "Русский" либо "Такой же как в Windows" (то есть тоже русский)

Как решение вроде логично попробовать установить англоязычную SSMS, но есть опасения, что 2 студии вместе не уживутся.

Да и вообще: хотелось бы оставить возможность переключения языка интерфейса с русского на английский.

How to change default language for SQL Server?

John Woo's user avatar

John Woo’s accepted answer has some caveats which you should be aware of:

  1. Default language setting of a T-SQL session in SQL Server Management Studio(SSMS) is inherited/overriden from/by Default language setting of the user login used to initiate the session instead. A new tab in SSMS creates a new T-SQL session. SQL Server instance level setting does not control the Default language setting of T-SQL session directly.
  2. Changing Default language setting at SQL Server instance level has no effect on the Default language setting of the already existing SQL Server logins. It is meant to be inherited only by the new user logins that we create after changing the instance level setting. So don’t be surprised if you changed the Default language setting at SQL Server instance level but it didn’t take effect for your user account. It is as per design.

So, there is an intermediate configuration level between SQL Server instance level and the T-SQL session level. It is called user login level. You can use this intermediate level configuration to control the Default language setting for T-SQL session without disrupting the SQL Server instance level settings.

This intermediate level setting is very helpful in case you want to set Default language setting to some value for all new T-SQL sessions(tabs in SSMS) belonging to some specific user.

We can change the Default language setting of the target user login as per this link. You can also achieve it from SSMS console e.g. we can change the Default language setting from the properties window of sa user in SQL Server via SSMS (Refer screenshot):

enter image description here

Note: Also, please remember that changing the setting at user login level will not have any effect on the Default language setting of already active T-SQL sessions (tabs in SSMS) created with that user login. It will affect only the new sessions which will be created after changing the setting.

Не меняется язык в SSMS. Как исправить?

Установила MICROSOFT SQL SERVER 2019 и MANAGEMENT STUDIO 18, при обеих установках был выбран русский язык, но отображается функционал на английском языке:
В свойствах сервера указан русский язык:

How to Set the Current Language in SQL Server (T-SQL)

In SQL Server, you can set the language to be used for the current session. The current language setting determines the language used on all system messages, as well as the date/time formats to use.

This article demonstrates how to use T-SQL to set the current language environment in SQL Server.


The syntax for setting the current language goes like this:


Where [N]’language’ | @language_var is the name of the language as stored in the sys.syslanguages system compatibility view. This argument can be either Unicode or DBCS converted to Unicode.

To specify a language in Unicode, use N‘language’. If specified as a variable, the variable must be of sysname data type (the sysname data type is used for table columns, variables, and stored procedure parameters that store object names).

Example 1 – Setting the Language

Here’s an example of setting the language for the current session to British:

Here’s an example of setting the language for the current session to German:

So we can see that the output is already in the newly specified language.

Example 2 – Running a Query

Changing the language impacts on how dates are formatted. Here’s an example to show what I mean.

First, we change the language to British , then run a query to convert a string into a date data type:

In this case, the date is translated as being the 9th of January.

Then we change the language to us_English and run the same query:

So in this case, the date was translated as being the 1st of September, due to the new language settings.

Setting the Language at the Query Level

Some T-SQL functions allow you to specify a language/culture to be used at the query level. For example, PARSE() accepts an optional argument that is used to determine how the provided string is formatted. This allows you to set the language/culture to be used only within that query (and even different parts of the query) without the need to change the language settings for the current session.

Here’s an example to demonstrate what I mean:

If you don’t provide this argument, the language of the current session is used.

Find the Current Language

You can run the following statement to return the language currently being used:

Find the Available Languages

You can run the following code to return a list of available languages:

This returns a list of all languages.

To narrow it down to a particular language, add the language name. Like this:


Добавить комментарий

Ваш адрес email не будет опубликован. Обязательные поля помечены *