By default, SQL Server uses rounding when converting a number to a decimal or numeric value with a lower precision and scale.

• 默认情况下,将数字转换为较低精度和小数位数的decimal或numeric值时,SQL Server会进行舍入。