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

问题描述

我想确定一个值是否为整数（如 TryParse 在.NET中）。 Unfortunatelly 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 为false，已经用科学计数表示的任何东西都被 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.

这篇关于T-sql - 确定值是否为整数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！