62,046
社区成员
发帖
与我相关
我的任务
分享
declare @num varchar(20)
set @num ='25.12312312'
select Case when CHARINDEX('.0000', Convert( decimal(10,4),@num))= 0 then Convert(varchar,convert(decimal(10,4) , @num))
else Convert(varchar,convert(decimal(10,0) , @num)) end
declare @num varchar(20)
set @num='25.00'
select (case when substring(@num,charindex('.',@num)+1,len(@num)-charindex('.',@num)+1)='0000'
then substring(@num,1,charindex('.',@num)-1) else substring(@num,1,charindex('.',@num)+4) end)
declare @s varchar(10)
set @s='25.00000'
select replace(substring(@s,1,charindex('.',@s)+4),'.0000','')
declare @num varchar(20)
set @num ='25.155622'
select convert( decimal(10,4), @num)