By applying SET LANGUAGE command you can work with different
language supported by Microsoft in the SQL Server. So this provides you a type
of globalization feature in SQL Server.
Example:
Query
DECLARE @Today DATETIME
SET @Today = 'SEPTEMBER 23 2008'
SET LANGUAGE Italian
SELECT DATENAME(month, @Today) AS 'Month Name'
SET LANGUAGE us_english
SELECT DATENAME(month, @Today) AS 'Month Name'
GO
The result window will be shown as follows:
Changed language setting to Italiano.
Month Name
------------------------------
settembre
(1 row(s) affected)
Changed language setting to us_english.
Month Name
------------------------------
September
(1 row(s) affected)