declare @f float;
declare @i int;
set @f = 123.789;
--set @i = convert(int, @f)
--set @i = cast(@f as int)
--set @i = ROUND(@f, 0, 1);//直接截取
set @i = ROUND(@f, 0); //四舍五入
select @i
declare @f float;
declare @i int;
set @f = 123.789;
--set @i = convert(int, @f)
--set @i = cast(@f as int)
--set @i = ROUND(@f, 0, 1);//直接截取
set @i = ROUND(@f, 0); //四舍五入
select @i
转载于:https://www.cnblogs.com/xiaoN-2006/archive/2013/01/23/2872953.html