I have a SQL server table with a decimal field set to precision 18 and scale 2. I am using a stored procedure to update this field which I am calling through code. The problem is as follows:

I feed the stored procedure parameter my value which is in the format "######.00", but when it gets to the database the value rounds to the nearest whole number.

Example: The parameter's value is set to 1.90; the value is 2 when it reaches the database.

Is there something I am overlooking here?