34,838
社区成员




select '数'=
case
when sum(t1)-sum(t3)+sum(t2)=0 then 'ok'
ELSE cast(sum(t1)-sum(t3)+sum(t2) as varchar(100))
END
select '数'=
case
when sum(t1)-sum(t3)+sum(t2)=0 then 'ok'
ELSE cast(sum(t1)-sum(t3)+sum(t2) as varchar)
END
select '数'=
case
when sum(t1)-sum(t3)+sum(t2)=0 then 'ok'
ELSE LTRIM(sum(t1)-sum(t3)+sum(t2))
END