sql语句 怎么去掉小数点后多余的 0
1个回答
展开全部
declare @s numeric(20,10)
set @s = 2555.784000
select
case when cast(@s as float) > cast(cast(@s as float) as INT)
then cast(@s as float)
else cast(cast(@s as float) as int)
end
set @s = 2555.784000
select
case when cast(@s as float) > cast(cast(@s as float) as INT)
then cast(@s as float)
else cast(cast(@s as float) as int)
end
本回答被网友采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
