which data type will be suitable for store these data ?

Question

I work on sql server 2017 i face issue which data type will be suitable for these data type
so are using decimal or float or which data type will be suitable for save data actually as it is

my data sample as below

MinFeatureValueNormalized
10000000
8
1
1
10000000
8
1
1
10000000
14
1
1
10000000
17
1
1
10000000
21
1
1
10000000
8
1
1
10000000
8
1
1
10000000
14
1
1
10000000
17
1
1
10000000
21

0.0000001
0.00001
0.0000001
0.00001
0.0000001
0.00001
0.0000001
0.00001
150
100
1.35
1.35
1.25
1.25
23
24
25
1.5
26
1.1
2.5
1.5
1001
1001
1001
1002
500000000
161
162
2510000000
161
162
5100000000
161
162
6100000000

Answer 1

Hi @ahmed salah ,

You should use decimal or numeric data types:

• https://learn.microsoft.com/en-us/sql/t-sql/data-types/decimal-and-numeric-transact-sql?view=sql-server-ver16
• https://www.tektutorialshub.com/sql-server/decimal-numeric-data-types-in-sql-server/

Answer 2

You should never use Float unless you can have some small errors in your numbers. Float is an "approximation" of a number and may not always represent exactly what you put in.

Answer 3

I would say that it depends on what the date represents. If they are measurements from a device, float makes perfect sense. If it is financial data, less so.