问在SQL Server中将小数点后两位数四舍五入并忽略小数点后的第三个值

EN

-- move decimal separator up
select 179.8744 * 100.0

-- round up to next integer
select ceiling(179.8744 * 100.0);

-- move decimal separator down (complete formula)
select ceiling(179.8744 * 100.0) / 100.0;

select cast(179.8744 as decimal(10,2))
OR
select round(179.8744,2)