CODEWITHSUNDEEP
sql-serverssms
deepz
deepz

Reputation: 225

SQL Server saves decimal(18,2) as 0,00 instead of 0.00

I upgraded SQL Server version from 2012 to 2014 and for some reasons, the data is saved as 0,00 instead of 0.00. Please advise as it wasn't happening in SQL Server 2012

SQL results

Upvotes: 0

Views: 449

Answers (1)

Attie Wagner
Attie Wagner

Reputation: 1362

Open Control Panel, then click on Region (if your View by is Large/Small Icons), otherwise, click on Clock & Region, then click on Region.

When that is opened, click on Additional Settings.

Navigate to the Decimal Symbol row as can be seen below:

enter image description here

Set the Decimal Symbol to ., then navigate to the Currency Tab and do the same for Decimal Symbol.

Click on Apply & OK, then Apply & OK.

That should resolve it.

Upvotes: 1

Related Questions