Need help in deciding on datatype declaration

Question

Hi I am not understanding whether i should declare selling price in that sql table as moneydecimal or int.. Which one is appropriate?

Pravin More · Answer

hi nethra i told you it in example...... for e.g moneyresult numericresult 2949.00 2949.8525 seeif you use money then you will get 2949.00 not 2949.8525 so its wrong.and if you loose .8 in every calculation then guess how much price will reduce if you are using that value in thousand number of time....... Thanks hopw i am able clear my point. Pravin.

Nethra R S · Answer

Thanks Pravin

Nethra R S · Answer

Hi Pravin Thanks for the reply. If you can further explain how it can cause problem further i will be grateful

Pravin More · Answer

Hi Nethra int is not proper and dont use money also it is not perfect type to hold price use decimal for price its perfect. money and decimal result will be same till decimal point onlyso money is not good for further calculations. for e.g moneyresult numericresult 2949.00 2949.8525 So use decimal only. Thanks Pravin.