drayyarb
March 26th, 2004, 02:00 PM
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?
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?