sqlserver

While using decimal data type
The statement decimal (p, s) with p as precision and s as scale represents a decimal number with up to p digits and s of them will be on the right of the decimal point.

DECLARE @d decimal(8, 3)
SET @d=12345.67
SELECT @d


12345.670 

Hi Narasiman,


Change the Data Type to


decimal(18, 1)


Thanks

Hi

Check the data type of column, in which you are storing value. I think it's int datatype.

If you want to store decimal values then take Float,decimal and numeric datatype instead of int.

Thanks

  hi narasiman,


  what was the data type you given to that field? check it?


if you given int means change that into float  or decimal ,numeric(10,2).


try this. 

Hint : numeric(10,2)

  2 represent maximum value display after decimal point.