SQL Server database inside the amount type why is not recommended with float, the instance tells you why not.

If you design data of the amount type in the project, have you ever considered why you cannot use the float type?

Here's an example:

DECLARE @price1 FLOAT; SET @price1 = 1; SET @price1 = (@price1 * 7.1)/7-@price1 * 0.1SELECT  @price1;D eclare @price2 DECIMAL; SET @price2 = 1; SET @price2 = (@price2 * 7.1)/7-@price2 * 0.1SELECT  @price2;

Execute to see how the results are:

0.914285714285714

1

Here is a record, the development of small problems encountered.

SQL Server database inside the amount type why is not recommended with float, the instance tells you why not.