QUESTION POSED ON: 05 November 2004 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.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.
