declare @a int , @b intselect @a=6, @b=3if @a%@b=0 and (@b<>0) print cast(@a as varchar)+'是'+cast(@b as varchar)+'的整数倍' else print cast(@a as varchar)+'不是'+cast(@b as varchar)+'的整数倍'-- 6是3的整数倍
select (case when 7%5 = 0 then N'整数倍' else N'色狼倍' end)/* ---- 色狼倍
print cast(@a as varchar)+'是'+cast(@b as varchar)+'的整数倍'
else
print cast(@a as varchar)+'不是'+cast(@b as varchar)+'的整数倍'--
6是3的整数倍
select (case when 7%5 = 0 then N'整数倍' else N'色狼倍' end)/*
----
色狼倍