I have a field in a table of type decimal(10,3)
so I want it sohuld be able to save the number upto 3 decimal places.
This is in SQL Server 2005
Now while saving this data the stored procedure has declared this field as decimal.
What is passes from the application-->
shippingquantity = CType(sShippingQty, Decimal)
sShippingQty is takrn from a text box
If I enter 20.345 the value in shippingquantity is 20.345
but when it saves this to the database it saves it as 20.000
Why so? Is decimal datatype not the correct datatype for this requirement?
What shall i use..what precision?