declare @t float set @t=3.1select cast(@t as int)select convert(int,@t)
CEILING 返回大于或等于所给数字表达式的最小整数。
楼主的意思是?不是转成int吗?
declare @flt floatset @flt=3.1 select cast(ceiling(@flt) as int) set @flt=3.2 select cast(ceiling(@flt) as int) set @flt=3.5 select cast(ceiling(@flt) as int) set @flt=3.6 select cast(ceiling(@flt) as int) set @flt=3.9 select cast(ceiling(@flt) as int)/*4 4 4 4 4 */
declare @flt floatset @flt=3.1 select cast(ceiling(@flt) as int) set @flt=3.2 select cast(ceiling(@flt) as int) set @flt=3.5 select cast(ceiling(@flt) as int) set @flt=3.6 select cast(ceiling(@flt) as int) set @flt=3.9 select cast(ceiling(@flt) as int)/*4 4 4 4 4 */
set @t=3.1select cast(@t as int)select convert(int,@t)
返回大于或等于所给数字表达式的最小整数。
declare @flt floatset @flt=3.1
select cast(ceiling(@flt) as int)
set @flt=3.2
select cast(ceiling(@flt) as int)
set @flt=3.5
select cast(ceiling(@flt) as int)
set @flt=3.6
select cast(ceiling(@flt) as int)
set @flt=3.9
select cast(ceiling(@flt) as int)/*4
4
4
4
4
*/
select cast(ceiling(@flt) as int)
set @flt=3.2
select cast(ceiling(@flt) as int)
set @flt=3.5
select cast(ceiling(@flt) as int)
set @flt=3.6
select cast(ceiling(@flt) as int)
set @flt=3.9
select cast(ceiling(@flt) as int)/*4
4
4
4
4
*/