1

Scenario:

I've a Sql Server instance on English Windows Server.

But I've my own ITALIAN client with Sql Server Management Studio and SSMS regional settings set to Italian.

So when I extract data, i need separator as follow :

, (comma) for decimal

. (point) for thousands

Example: 1.065,00

Instead , Sql Server Management Studio return me number like:

1065.0000

(point for decimal separator)

If I copy & paste into Excel all data are mess..

How can I do without writing specific query with "Format" or similar ?

Thanks

Example : point , but i need comma! enter image description here

2
  • Hi @stighy, I use Italian regional setting as well and I never faced such problem. Can you paste a picture of the data in SSMS and exported to Excel? Thank you Oct 28 '20 at 21:54
  • Added a screenshot thanks Francesco
    – stighy
    Oct 29 '20 at 8:59
0

SSMS is inconsistent. For some data types, it uses comma (I'm Swedish) as decimal separator. For other types, it uses dot.

For money and float SSMS presents comma, but for decimal I get dot. None of them gives me a thousand separator.

SELECT CAST(3000.1 AS money), CAST(3000.1 AS float), CAST(3000.1 AS decimal(9,2))

I guess that one could consider the inconsistency a bug.

SSMS was never designed to be an end-user tool, so we pretty much have to accept what we are given. If we don't like how SSMS present the data returned from SQL Server we can open a feature request for this to Microsoft: https://feedback.azure.com/forums/908035-sql-server

I wouldn't have too much hope for this to be addressed.

3
  • Tibor, does ADS have the same (or similar) incorrect handling of regionalization? Or would using ADS be a possible work around?
    – AMtwo
    Oct 28 '20 at 16:10
  • Tibor, what do you suggest as alternative to SSMS
    – stighy
    Oct 28 '20 at 16:43
  • ADS at least uses comma as decimal separators for all the three types in my example. I do remember it used dot for decimal at some point, so they seem to have fixed that. I don't have the need you do, but I would probably define my needs (if you have further) and request them for ADS. Oct 28 '20 at 18:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.