By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
I am using the money data type in SQL Server 2000. When I display values on my production server (using ASP.NET), it shows two places after decimal, but on the live server it shows four digits after the decimal. What setting is required to get this rectified on my live server?
That is because your ASP.NET application is rounding them off. Money values are stored with 4 decimal places and you can find this explicitly documented in Books Online.