sqlserver

Question

in sqlserver database when i type 2.5 and save they did not taken decmical values how to do.when i save and again open only 2 not 2.5. i need 2.5. how to do.please help me Rgds Narasiman P

Pankaj Rana · Answer

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

Satyapriya Nayak · Answer

Hi Narasiman Change the Data Type to decimal(18 1) Thanks

Manish Dwivedi · Answer

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 Floatdecimal and numeric datatype instead of int. Thanks

sudharsan s · Answer

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(102). try this. Hint : numeric(102) 2 represent maximum value display after decimal point.