- 博客(1)
- 资源 (1)
- 收藏
- 关注
转载 SQL判断一个数是整数还是小数
DECLARE @number1 AS numeric(10,2),@number2 AS numeric(10,2)SELECT @number1=10.00,@number2=10.2SELECT CASE WHEN CAST(@number1 AS INT)=@number1 THEN '整数' ELSE '小数' END,CASE WHEN CAST(@number2 AS I
2012-10-24 09:28:45 24715 2
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人