About not rounding off value in sql

Question

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 !

satheesh d · Answer

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 Singh · Answer

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

Jignesh Kumar · Answer

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)

Guest User · Answer

thank you all for your replies

Sachin Singh · Answer

yes, decimal(38,6) is ok.

Guest User · Answer

Thank you all for your reply can I use datatype as decimal(38, 6) in sql, instead decimal(18, 6) or decimal(18, 2)?

Srinivasan Ramamoorthi · Answer

Need to update column datatype to include decimal point’s.