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:
|
1 2 3 4 |
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.
|
1 2 3 4 5 6 7 |
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
|
1 2 3 4 5 6 7 8 |
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
Share your Feedback, or Code!!