Decimal Truncation using SqlParameter

Jul 26 2004 1:29 PM
Trying to store/retrieve records containing Decimal fields and the numbers are being rounded to a whole number. Using C#, ADO(MDAC 2.8), and SQL Server 2000. I am setting the Precision and Scale (18, 2) on the SqlParameter and having no luck with the retrieval or inserting numeric fields with a fractional value. Any ideas would be greatly appreciated. Thanks...

Answers (5)