Decimal to decimal
When a decimal number is assigned to a decimal column or variable, the number is converted, if necessary, to the precision and the scale of the target.
The necessary number of leading zeros is added or eliminated, and, in the fractional part of the number, the necessary number of trailing zeros is added, or the necessary number of trailing digits is eliminated.