在SQL中 怎么判断查询的是整数

oracle

select * form table where mod(数值,1) = 0

sqlserver

select * from table where 数值 = round(数值,0)

create TRIGGER tr_A_Insert ON A

WITH ENCRYPTION

for insert

AS

BEGIN

DECLARE @a VARCHAR(100)

SET @a = (select a FROM inserted)

IF isnumeric(substring(@a,1,8)) = 1 and floor(substring(@a,1,8))=substring(@a,1,8)

begin

INSERT INTO B(b) VALUES(@A)

end ELSE

IF isnumeric(substring(@a,1,4)) = 1 and floor(substring(@a,1,4))=substring(@a,1,4)

BEGIN

INSERT INTO C(c) VALUES(@A)

END

END

---