A question about using Decimal with Stored Procedure

I

Ing. Rajesh Kumar

Hi everybody
I have a DECIMAL column with scale = 2. When I insert data into this column from a web page using Stored procedure, the data is rounded up. but when I use a query instead, then things are OK.
For example :
I want to insert : 24.60
With SP it insert 25
With direct Insert query it insert : 24.60

Why so with SP ?
Thanks
Raja
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,581
Members
45,057
Latest member
KetoBeezACVGummies

Latest Threads

Top