I have a query looking like this:
SELECT DATENAME(month, GETDATE()) + ', ' + CONVERT(NVARCHAR(4),year(GETDATE()),121) AS 'Month Name'
This renders the following result:
But say that I would like to have the month name in Swedish instead. That would then be rendered as "Oktober, 2013".
Is this possible to alter?