Hi...
can anyone plzz suggest me as to how to assign a datatype in sql server for a column(field) which should accept decimal,double or float data as per the result which is obtained in front end.The problem is I have given the "Float" datatype to this field.And for ex: If the result is 12.56 then it is storing the value as 12.5600004196167 in the Database.
And again when I display this value,it is showing this long number on screen which looks very incorrect.
And if I give the datatype as Numeric(15,5) for the column(field) in sql server,so that after decimal point it can store 5 digits, another problem is arising that is.If for ex:If I enter 12.56 then it is storing the value as 12.56000 in the database.
Which datatype should I choose so that it stores the exact value (i.e whatever I enter) into database without any changes.
Plzzzzzzzz help..
siri