SQL LANGUAGE

The SQL LANGUAGE is one of the Set Function, which will set the Language or change the default language. This Set language Statement determines the system message, and datetime format. This article will show you, How to use the SET LANGUAGE in SQL Server with example. Before we get into the example, let us see the syntax behind this:

SQL LANGUAGE Syntax

The basic syntax of the LANGUAGE in SQL Server is as shown below:

SET LANGUAGE Language_Name

-- For example,
SET LANGUAGE French;

SQL LANGUAGE Example

In this example we will show you, How the SET LANGUAGE in SQL Server will affect the datetime, and message formats. if you find it difficult to understand the language names then use 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'

OUTPUT

Let me show you the 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.

Thank You for Visiting Our Blog