SQL Server retains decimal resolution

In the database, we sometimes use decimals, how to convert the decimal in the database, the following are some common methods.

1. Use the round (field name/number, decimal reserve number) method as follows:

Select Round (3.333,2)

The results are as follows:

2. Use the CONVERT (decimal (18, decimal reserved digit), field name/number method, as follows:

Select Convert (Decimal (18,1), 3.333)

The results are as follows:

The difference between the two methods is that the number of digits after the decimal point of the round function is constant, the number following the reserved digit is replaced by 0, and the Convert method retains only the number of decimal places you need.

SQL Server retains decimal resolution