About not rounding off value in sql

Guest User

4y1.1k.NET

hello,

hope everyone is doing fine

I am saving value as 14356.78 in sql database, I can see value as 14356.78 in breakpoint.

But in database it is saved as 143568, which I don't want

The datatype i tried is decimal, float and varchar, still it is rounding off automatically

I want to prevent rounding off after saving in sql db

thank you !

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User4y ago
thank you all for your replies
satheesh d4y ago
We can use the Decimal data type which is suitable for the string the data that includes decimal. Otherwise if we use normal int or any other dtaatype, it rounded of the value and stored in database. Here If you are used decimal, then make sure that scale value is not as 0.
Syntax : coumn_name DECIMAL(P,S);
Here P refers to the precision and it is the maximum total number of decimal digits that can be stored both to the right and left of decimal point.
And S refers to Scale and this ia a number of decimal digits that will be stored to the right of decimal point.
By doing so,we can get the exact decimal value without being rounded off.
Sachin Singh4y ago
yes, decimal(38,6) is ok.
Guest User4y ago
Thank you all for your reply
can I use datatype as decimal(38, 6) in sql, instead decimal(18, 6) or decimal(18, 2)?
Sachin Singh4y ago
No, SQL Server round values only during conversion if your datatype is varchar, if it is decimal then it will not round.
make sure that it is not decimal(18,0)
use
decimal(18,2) or decimal(18,6) etc
Srinivasan Ramamoorthi4y ago
Need to update column datatype to include decimal point’s.
Jignesh Kumar4y ago
Hi Sushant,

I think issue with your table column datatype. Please check your column datatype if not decimal(10, 2) then make it.

Please use this script to change datatype,

ALTER TABLE your_tablename MODIFY your_column_name decimal(10, 2)

Note : If you are using store procedure apply same change like parameter as decimal(10, 2)