Sep 13, 2017 07:57 AM|PatriceSc|LINK
A database is just storing values and doesn't care about formatting. It just happens that values are always *shown* according to some convention. For decimal columns, SQL Server Management Studio shows all decimal places (ie you likely have something such
Your web app should show the value without non significant 0 digits (ie 12.3 assuming your web app is configured for a country which uses . rather than some other symbol for the decimal point).
In short you have to make the difference between the actual value (ie 12.3 is 12.3 every on earth) and how it is shown (12.3 12,3 12.30000 is just 3 ways to show the same value depending on which convention is used).