How to solve issue of IE data on float numbers and on same time save data as it is without change ?

Question

How to solve issue of IE data on float numbers and on same time save data as it is without change ?

ahmed salah 3,216

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)

Answer accepted by question author

1 additional answer

Your answer

Answer 1

Jingyang Li 5,901 Volunteer Moderator

Use decimal(15,7) or numeric(15,7).

ahmed salah 3,216 Reputation points

2022-06-05T07:12:54.983+00:00

but data on float type will change
as example
8 will be 8.00000
i don't need add 0 on right of values
ahmed salah 3,216 Reputation points

2022-06-05T08:38:12.673+00:00

how to write query detect numbers like IE only
i need to write query detect numbers like IE only
ahmed salah 3,216 Reputation points

2022-06-05T08:45:54.83+00:00

what i try but not working
SELECT case when numbers like '%E-%' then 0 else cast(numbers as double precision) end as castedvalue
FROM #TestTable

Answer 2

Erland Sommarskog 128.9K MVP Volunteer Moderator

You are confusing the string representation with the presentation of the number in SSMS. A float value is always stored with a 53-bit base umber and an 11-bit exponent of 2. When presenting the data as string SSMS wil use scientific notation in most cases, but numbers around 1 are presented without exponent.

Share via

How to solve issue of IE data on float numbers and on same time save data as it is without change ?

1 additional answer

Your answer