T-sql - 确定值是否为整数

2021-12-10 00:00:00 integer casting tsql sql-server isnumeric

我想确定一个值是否为整数(如 .NET 中的 TryParse).不幸的是 ISNUMERIC 不适合我,因为我只想解析整数而不是所有类型的数字.有没有ISINT之类的东西?

I want to determine if a value is integer (like TryParse in .NET). Unfortunatelly ISNUMERIC does not fit me because I want to parse only integers and not every kind of number. Is there such thing as ISINT or something?

这里有一些代码可以让事情变得清晰.如果 MY_FIELD 不是 int,则此代码将失败:

Here is some code to make things clear. If MY_FIELD is not int, this code would fail:

SELECT @MY_VAR = CAST(MY_FIELD AS INT)
FROM MY_TABLE
WHERE MY_OTHER_FIELD = 'MY_FILTER'

谢谢

推荐答案

这是一篇博文 描述 IsInteger UDF 的创建.

Here's a blog post describing the creation of an IsInteger UDF.

基本上,它建议将 '.e0' 添加到值并使用 IsNumeric.这样,任何已经有小数点的东西现在都有两个小数点,导致 IsNumeric 为假,并且任何已经用科学计数法表示的东西都被 e0 无效.

Basically, it recommends adding '.e0' to the value and using IsNumeric. In this way, anything that already had a decimal point now has two decimal points, causing IsNumeric to be false, and anything already expressed in scientific notation is invalidated by the e0.

相关文章