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
Instead , Sql Server Management Studio return me number like:
(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 ?