DECLARE @number1 AS numeric(10,2),@number2 AS numeric(10,2)
SELECT @number1=10.00,@number2=10.2
SELECT
CASE WHEN CAST(@number1 AS INT)=@number1 THEN '整数' ELSE '小数' END,
CASE WHEN CAST(@number2 AS INT)=@number2 THEN '整数' ELSE '小数' END
SQL判断一个数是整数还是小数
最新推荐文章于 2024-07-30 03:53:22 发布