SQL SET LANGUAGE

The SQL LANGUAGE is one of the Set Functions, which will set the Language or change the default language. This Set language Statement determines the system message and DateTime format. The syntax of SET language is

SET LANGUAGE Language_Name

SQL SET LANGUAGE Example

In this example, we will show you, How the SET LANGUAGE will affect the DateTime and message formats. If you find it challenging to understand the language names, then use the sp_helplanguage stored procedure.

SELECT DATENAME(month, GETDATE()) AS 'Month Name'

SET LANGUAGE French
SELECT DATENAME(month, GETDATE()) AS 'Month Name'

SET LANGUAGE Italian
SELECT DATENAME(month, GETDATE()) AS 'Month Name'

Let me show you the SQL Server system messages. For this, we are selecting divide by zero statement

SET LANGUAGE English
SELECT 1/0 

SET LANGUAGE French
SELECT 1/0 

SET LANGUAGE Italian
SELECT 1/0

You can see the message in different languages.