I work on sql server 2017 i face issue when save data on float column data type
it saved as IE-07 AND ie-05 so what this and how to handle it please
how to save data on float numbers as it is
if there are any way to save data on correct way on another data type please tell me
my sample data
create table #numbersfloat
(
Numbers float
)
insert into #numbersfloat(Numbers)
values
(0.0000001),
(0.00001),
(0.0000001),
(0.00001),
(0.0000001),
(0.00001),
(0.0000001),
(0.00001),
(10000000),
(8),
(1),
(10000000),
(14),
(10000000),
(1005)
What I have tried:
data on float column data type display as IE so how to solve it and on same time how to save another data as it is