自己写一函数实现,
正数用floor,负数用ceiling
create function trunc(@inputnum float,@num int)
returns float
as
begin
declare @result float
if @inputnum>=0
set @result=floor(@inputnum*power(10,@num))/power(10,@num)
else
set @result=ceiling(@inputnum*power(10,@num))/power(10,@num)
return @result
end