34,590
社区成员
发帖
与我相关
我的任务
分享
declare @i int , @j int
set @i=100
set @j=88
select (case when @i is null then '0' when @i=0 then '0' else convert(varchar(10),convert(decimal(10,2),@j*1.0/@i*100))+'%' end) as jsjhl
declare @i int , @j int
set @i=100
set @j=88
select (case when isnull(@i,'')=0 then '0' else convert(varchar(10),convert(decimal(10,2),@j*1.0/@i*100))+'%' end) as jsjhl
declare @i int , @j int
set @i=100
set @j=88
select (case when @i is null then '0' when @i=0 then '0' else convert(varchar(10),convert(decimal(10,2),@j*1.0/@i*100))+'%' end) as jsjhl
declare @i int , @j int
set @i=100
set @j=88
select (case when @i is null then '0' when @i=0 then '0' else convert(varchar(10),convert(decimal(10,2),@j*1.0/@i*100))+'%' end) as jsjhl