Regarding data type

Question

I use a money type for a amount field in sql using aspx when i use inesrt query same value insert which i give but when i get a report then the value is changed eg:> in sql 1000 amount is stored but in report the value is 10000

Rajkiran Swain · Answer

https://stackoverflow.com/questions/582797/should-you-choose-the-money-or-decimalx-y-datatypes-in-sql-server

Narinder Singh · Answer

I already use a decimal(183) type in sql but when query get data on a pge then the 1000 amount show as a 10000.000

Manikandan Murugesan · Answer

As it is described at decimal as The decimal keyword indicates a 128-bit data type. Compared to floating-point types the decimal type has more precision and a smaller range which makes it appropriate for financial and monetary calculations. You can use a decimal as follows: decimal myMoney = 300.5m;