Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Compute Balance In Query
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01379592
Message ID:
01379707
Vues:
30
Naomi,

That's pretty much of a red herring example they are using. Money math involves a fixed 4 decimal places. As long as one understands this there are no problems. It also points out an "error" in the decimal division handling, clearly an intermediate type other than decimal(19,4) is being used because otherwise the extra decimal places would not be visible after the division occured.

Money is a perfectly good datatype and should be used where it's appropriate.

>Also it's not a good idea to use MONEY type.
>
>See http://forums.asp.net/t/1380719.aspx
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform