I have a Sql Server instance on English Windows Server.
But I also have 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
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..
Example: point , but i need comma!
How can I do without writing specific query with "Format" or similar?