判断是整型问题

[Coolyu0916]

在线
如何判断一列是整型
ISNUMERIC不能判断小数点

[sdhdy]

select * from tablename where isnumeric(colname)=1 and charindex('.',cast(colname as varchar))=0

[sdhdy]

select * from tablename where isnumeric(colname)=1 and charindex('.',cast(colname as varchar(100)))=0

[愉快的登山者]

if @a = cast(@a as int)

[zjcxc]

select * from 表 where isnumeric(字段名)=1 and 字段名 not like '%.%'

[愉快的登山者]

select * from tablename where colname = cast(colname as int)

[zjcxc]

如果是查询的话,建议用我的方法,这样效率会高一些.

[Coolyu0916]

thanks