您好,结果不对哦。select cast(1.121 as decimal(18,2))我这边结果是1.12,而我要的结果是1.13
select cast(ceiling(0.00000009*100)/100 as decimal(18,2)) select cast(ceiling(0.122*100)/100 as decimal(18,2))
select cast(ceiling(数据*100)/100 as dec(18,2)) from tb
create table tb(col decimal(18,10)) insert into tb values(0.001) insert into tb values(0.09) insert into tb values(0.009) insert into tb values(0.00000009) insert into tb values(0.122) go select cast(case when col * 100 - cast(col * 100 as int) = 0 then cast(col * 100 as int) else cast(col * 100 as int) + 1 end/100.0 as decimal(18,2)) From tbdrop table tb/*
select cast(ceiling(0.00000009*100)/100 as decimal(18,2))
select cast(ceiling(0.122*100)/100 as decimal(18,2))
insert into tb values(0.001)
insert into tb values(0.09)
insert into tb values(0.009)
insert into tb values(0.00000009)
insert into tb values(0.122)
go
select cast(case when col * 100 - cast(col * 100 as int) = 0
then cast(col * 100 as int)
else cast(col * 100 as int) + 1
end/100.0 as decimal(18,2))
From tbdrop table tb/*
--------------------
.01
.09
.01
.01
.13(所影响的行数为 5 行)
*/