DECLARE @Number1 AS numeric(12,2),@Number2 AS numeric(12,2)
SELECT @Number1=30.00,@Number2=32.2
SELECT
CASE WHEN CAST(@Number1 AS Int)=@Number1 THEN '整数' ELSE '小数' END,
CASE WHEN CAST(@Number2 AS Int)=@Number2 THEN '整数' ELSE '小数' END
SELECT
CASE WHEN Cast(@Number1 as Int)=@Number1 THEN Cast(Cast(@Number1 as decimal(18,0)) as varchar(20))
ELSE Cast(Cast(@Number1 as decimal(18,1)) as varchar(20)) END as Number1,
CASE WHEN Cast(@Number2 as Int)=@Number2 THEN Cast(Cast(@Number2 as decimal(18,0)) as varchar(20))
ELSE Cast(Cast(@Number2 as decimal(18,1)) as varchar(20)) END as Number2