sql server round函数

关于ROUND函数，我们平常理解为4舍5入，如：

print ROUND(12.555, 2);

结果为：12.560

float 和 real 数据类型被称为近似数据类型,需要舍入的操作或等值核对中，请勿使用这些数据类型.而应使用decimal

declare @Value1 decimal(18,2), @Digit1 int
set @Value1=12.055;
set @Digit1=2;
print '12.055 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.155;
print '12.155 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.255;
print '12.255 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.355;
print '12.355 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.455;
print '12.455 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.555;
print '12.555 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.655;
print '12.655 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.755;
print '12.755 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.855;
print '12.855 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.955;
print '12.955 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);

12.055 --> 12.06
12.155 --> 12.16
12.255 --> 12.26
12.355 --> 12.36
12.455 --> 12.46
12.555 --> 12.56
12.655 --> 12.66
12.755 --> 12.76
12.855 --> 12.86
12.955 --> 12.96

--以下修改数据类型为 float
declare @Value1 float, @Digit1 int
set @Value1=12.055;
set @Digit1=2;
print '12.055 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.155;
print '12.155 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.255;
print '12.255 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.355;
print '12.355 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.455;
print '12.455 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.555;
print '12.555 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.655;
print '12.655 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.755;
print '12.755 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.855;
print '12.855 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);
set @Value1=12.955;
print '12.955 --> ' + cast(ROUND(@Value1, @Digit1) as varchar);


12.055 --> 12.05
12.155 --> 12.15
12.255 --> 12.26
12.355 --> 12.36
12.455 --> 12.46
12.555 --> 12.55
12.655 --> 12.65
12.755 --> 12.76
12.855 --> 12.86
12.955 --> 12.96