Hi guys,

I have a problem with my sql database. In my database, column Quantity has a data type of decimal. But why everytime I am trying to insert 1.25 in column quantity, and query it the result is 1. Where's 0.25?

My code for asp.net is:

Code:
decimal qty = decimal.Parse(quantity);
And for Stored Procedure:

Code:
@Quantity DECIMAL
Do I have to use float instead of decimal?

Thanks very much in advance