blocks|key|1282438|text|一种方法是|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1282439|zipcode+NOT+LIKE+'%25[%5E0-9]%25'|code-block|syntax|javascript|1282440|双重否定，我爱死他们了！|1282441|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

1 approach is

<pre><code>zipcode NOT LIKE '%[^0-9]%'
</code></pre>

Double negatives, got to love 'em!

blocks|key|159535|text|处理负数的较晚条目|type|unstyled|depth|inlineStyleRanges|entityRanges|data|159536|ISNUMERIC(zipcode+%2B+'.0e0')+--integer
ISNUMERIC(zipcode+%2B+'e0')++--decimal|code-block|syntax|javascript|159537|有关更多信息，请参阅this|offset|length|159538|entityMap|0|LINK|mutability|MUTABLE|url|http://www.tek-tips.com/faqs.cfm?fid=6423^0|0|0|A|4|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

Late entry that handles negative

<pre><code>ISNUMERIC(zipcode + '.0e0') --integer
ISNUMERIC(zipcode + 'e0') --decimal
</code></pre>

For more see <a href="http://www.tek-tips.com/faqs.cfm?fid=6423" rel="noreferrer">this</a>

blocks|key|908407|text|如果SQL+Server是2005%2B，我会选择enable+CLR+and+create+the+function+to+support+regexes。对于SQL+Server2000，使用see+this+article+for+creating+a+UDF+to+do+the+same+thing。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|908408|然后我将使用正则表达式：%5E\d{5}$|style|CODE|908409|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/magazine/cc163473.aspx|1|http://www.sqlteam.com/article/regular-expressions-in-t-sql^0|N|1H|0|2O|1K|1|0|C|7|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]|$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@$A|Z|B|10|F|G]]|9|@]|C|$]]|$1|H|3|-4|5|6|7|11|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]]]

If SQL Server 2005+, I'd <a href="http://msdn.microsoft.com/en-us/magazine/cc163473.aspx" rel="noreferrer">enable CLR and create the function to support regexes</a>. For SQL Server 2000, <a href="http://www.sqlteam.com/article/regular-expressions-in-t-sql" rel="noreferrer">see this article for creating a UDF to do the same thing</a>.

Then I'd use the regex: <code>^\d{5}$</code>

blocks|key|1282543|text|此表达式为1表示整数值，否则为0|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1282544|floor((floor(abs(zipcode)))/abs(zipcode))|code-block|syntax|javascript|1282545|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This expression gives 1 for an integer value and 0 otherwise

<pre><code>floor((floor(abs(zipcode)))/abs(zipcode))
</code></pre>

blocks|key|1282598|text|为什么不直接使用下面的代码呢？我找不到任何失败的案例。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1282599|1282600|1+=整数|unordered-list-item|1282601|0=非整数|1282602|null=非数字|1282603|1282604|DECLARE+@TestValue+nvarchar(MAX)
SET+@TestValue+=+'1.04343234e5'

SELECT+CASE+WHEN+ISNUMERIC(@TestValue)+=+1
++++++++THEN+CASE+WHEN+ROUND(@TestValue,0,1)+=+@TestValue
++++++++++++THEN+1
++++++++++++ELSE+0
++++++++++++END
++++++++ELSE+null
++++++++END+AS+Analysis|code-block|syntax|javascript|1282605|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|S|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|U|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|V|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|W|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|X|8|@]|9|@]|A|$N|O]]|$1|P|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|Q|$]]

Why not just use the following? I can't see to find any cases where it fails.

<ul>
<li>1 = integer</li>
<li>0 = not integer</li>
<li>null = non-numeric</li>
</ul>

<pre><code>DECLARE @TestValue nvarchar(MAX)
SET @TestValue = '1.04343234e5'

SELECT CASE WHEN ISNUMERIC(@TestValue) = 1
 THEN CASE WHEN ROUND(@TestValue,0,1) = @TestValue
 THEN 1
 ELSE 0
 END
 ELSE null
 END AS Analysis
</code></pre>

blocks|key|905532|text|我在另一个StackO问题上想出了这个问题的完美答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|905533|这也证明了不能像一个用户在这里建议的那样使用".0e0“。|offset|length|style|BOLD|905534|它不使用CLR或非标量函数。|905535|请查看：https://stackoverflow.com/a/10645764/555798|905536|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/10645764/555798^0|0|5|F|0|0|4|17|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@$D|V|E|W|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|Y|8|@]|9|@$D|Z|E|10|1|11]]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]]]

I came up with the perfect answer for this on another StackO question.
 It also proves you cannot use ".0e0" like one user suggests here.
 It does so without CLR or non-scalar functions.
 Please check it out: <a href="https://stackoverflow.com/a/10645764/555798">https://stackoverflow.com/a/10645764/555798</a>

blocks|key|2691654|text|在迁移到SQL2008之后，我遇到了isnumeric('\8')返回true，但在转换为整数时抛出错误的问题。显然，正斜杠是日元或韩元的有效货币-(参考http://www.louiebao.net/blog/200910/isnumeric/)|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2691655|我的解决方案是|2691656|case+when+ISNUMERIC(@str)+>+0+and+not+rtrim(@str)+LIKE+'[%5E0-9]%25'++and+not+rtrim(@str)+LIKE+'%25[%5E0-9]'+and+not+rtrim(@str)+LIKE+'[%5E0-9]%25'+then+rtrim(@str)+else+null+end|code-block|syntax|javascript|2691657|entityMap|0|LINK|mutability|MUTABLE|url|http://www.louiebao.net/blog/200910/isnumeric/^0|25|1A|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

After moving to sql 2008, I was struggling with isnumeric('\8') returning true but throwing an error when casting to an integer. Apparently forward slash is valid currency for yen or won - (reference <a href="http://www.louiebao.net/blog/200910/isnumeric/" rel="nofollow">http://www.louiebao.net/blog/200910/isnumeric/</a>)

My solution was

<pre><code>case when ISNUMERIC(@str) &gt; 0 and not rtrim(@str) LIKE '[^0-9]%' and not rtrim(@str) LIKE '%[^0-9]' and not rtrim(@str) LIKE '[^0-9]%' then rtrim(@str) else null end
</code></pre>

blocks|key|905589|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|905590|查看下面的代码是否有帮助。在下面的值中，只有9、2147483647、1234567有资格作为整数。我们可以将它创建为函数，并使用它。|blockquote|905591|905592|905593|CREATE+TABLE+MY_TABLE(MY_FIELD+VARCHAR(50))
INSERT+INTO+MY_TABLE
VALUES('9.123'),('1234567'),('9'),('2147483647'),('2147483647.01'),('2147483648'),+('2147483648ABCD'),('214,7483,648')

SELECT+*
FROM+MY_TABLE
WHERE+CHARINDEX('.',MY_FIELD)+=+0+AND+CHARINDEX(',',MY_FIELD)+=+0+++++++
AND+ISNUMERIC(MY_FIELD)+=+1+AND+CONVERT(FLOAT,MY_FIELD)+/+2147483647+<=+1
DROP+TABLE+MY_TABLE|code-block|syntax|javascript|905594|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|-4|4|5|6|M|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|N|7|@]|8|@]|9|$]]|$1|D|3|-4|4|5|6|O|7|@]|8|@]|9|$]]|$1|E|3|-4|4|5|6|P|7|@]|8|@]|9|$]]|$1|F|3|G|4|H|6|Q|7|@]|8|@]|9|$I|J]]|$1|K|3|-4|4|5|6|R|7|@]|8|@]|9|$]]]|L|$]]

<blockquote>
 See whether the below code will help.
 In the below values only 9, 2147483647, 1234567 are eligible as
 Integer. We can create this as function and can use this.
</blockquote>

<pre><code>CREATE TABLE MY_TABLE(MY_FIELD VARCHAR(50))
INSERT INTO MY_TABLE
VALUES('9.123'),('1234567'),('9'),('2147483647'),('2147483647.01'),('2147483648'), ('2147483648ABCD'),('214,7483,648')

SELECT *
FROM MY_TABLE
WHERE CHARINDEX('.',MY_FIELD) = 0 AND CHARINDEX(',',MY_FIELD) = 0 
AND ISNUMERIC(MY_FIELD) = 1 AND CONVERT(FLOAT,MY_FIELD) / 2147483647 &lt;= 1
DROP TABLE MY_TABLE
</code></pre>

blocks|key|159639|text|我使用了一个Case语句:+Cast(Case+When+Quantity/#+of+Days=+Cast(Quantity/#+of+Days+as+int)+Then+abs(Quantity/Quantity+of+Days)+Else+0+End+as+int)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|159640|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I did it using a Case statement:
Cast(Case When Quantity/[# of Days]= Cast(Quantity/[# of Days] as int) Then abs(Quantity/[# of Days]) Else 0 End as int)

blocks|key|1282766|text|为了检验输入值是否为整数，我们可以使用SQL+SERVER的SQL_VARIANT_PROPERTY函数。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1282767|以下SQL脚本将获取输入并测试其数据类型是否为整型|1282768|declare+@convertedTempValue+bigint,+@inputValue+nvarchar(255)+=+'1'+--Change+'1'+to+any+input+value
set+@convertedTempValue+=+TRY_PARSE(@inputValue+as+bigint)+--we+trying+to+convert+to+bigint
declare+@var3+nvarchar(255)+=+cast+(SQL_VARIANT_PROPERTY(@convertedTempValue,'BaseType')+as+nvarchar(255))+--we+using+SQL_VARIANT_PROPERTY+to+find+out+datatype
if+(+@var3+like+'%25int%25')
++++begin
++++print+'value+is+integer'
++++end
else
++++begin
++++print+'value+is+non+integer'
++++end
go|code-block|syntax|javascript|1282769|entityMap^0|U|K|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|S|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

To test whether the input value is an integer or not we can use SQL_VARIANT_PROPERTY function of SQL SERVER. 

The following SQL Script will take input and test it whether the data type turns out to be integer or not

<pre><code>declare @convertedTempValue bigint, @inputValue nvarchar(255) = '1' --Change '1' to any input value
set @convertedTempValue = TRY_PARSE(@inputValue as bigint) --we trying to convert to bigint
declare @var3 nvarchar(255) = cast (SQL_VARIANT_PROPERTY(@convertedTempValue,'BaseType') as nvarchar(255)) --we using SQL_VARIANT_PROPERTY to find out datatype
if ( @var3 like '%int%')
 begin
 print 'value is integer'
 end
else
 begin
 print 'value is non integer'
 end
go
</code></pre>

blocks|key|2691807|text|这真的太晚了，但这能行得通吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2691808|select+*+from+from+table+
where+(ISNUMERIC(zipcode)+=+0+OR+zipcode+like+'%25.%25')|code-block|syntax|javascript|2691809|筛选出整数项。|2691810|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Really late to this but would this work?
<pre class="lang-sql prettyprint-override"><code>select * from from table 
where (ISNUMERIC(zipcode) = 0 OR zipcode like '%.%')
</code></pre>
Filters out items that are integers.

blocks|key|908623|text|看起来这个问题需要一个更新的答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|908624|限制问题标题的答案：|908625|where+ISNUMERIC(zipcode)+=+1
++and+zipcode+-+FLOOR(zipcode)+=+0|code-block|syntax|javascript|908626|根据问题的正文进行阐述。|908627|当前支持的SQL+Server版本都支持/包含TRY-CONVERT函数。|offset|length|style|CODE|908628|declare+@a+varchar(100)
set+@a+=+'-1.2a'
--set+@a+=+'-1.2'
--set+@a+=+'-1'
--set+@a+=+'-1.0'
--set+@a+=+'-0'
--set+@a+=+'0'
--set+@a+=+'1'

select+@a+as+'Value'
,+ISNUMERIC(@a)+as+ISNUMERIC
,+case+when+ISNUMERIC(@a)+=+1+and+@a+-+FLOOR(@a)+=+0+then+1+else+0+end+as+ISINTEGER
,+case+when+try_convert(int,+@a)+>=+0+and+left(@a,+1)+<>+'-'+then+1+else+0+end+as+ISWHOLENUMBER
,+case+when+try_convert(int,+@a)+>+0+then+1+else+0+end+as+ISCOUNTINGNUMBER|908629|您将注意到TRY_CONVERT(INT,+-1.0)返回NULL。所以对于ISINTEGER来说，TRY_CONVERT(INT,+@a)+IS+NOT+NULL并不是很合适。|908630|case+when+ISNUMERIC(@a)+=+1+and+@a+-+FLOOR(@a)+=+0+then+1+else+0+end+as+ISINTEGER|908631|...works，因为如果ISNUMERIC(@a)+=+1为false，则不计算FLOOR(@a)。颠倒顺序...|908632|case+when++@a+-+FLOOR(@a)+=+0+and+ISNUMERIC(@a)+=+1+then+1+else+0+end+as+ISINTEGER|908633|当值(@a)不是数字时...generates错误。|908634|因此，对于zipcode，假设您想要验证一个5位数字的邮政编码是一个数字，它必须是5位数字(因此它不能是0或更小)，并且永远不会包含小数点(因此您不需要知道12345.000是否是整数)：|908635|where+try_convert(int,+zipcode)+>+0
++and+len(zipcode)+=+5|908636|entityMap^0|0|0|0|0|N|B|0|0|5|M|T|4|12|9|1E|W|0|0|D|H|15|9|0|0|0|5|7|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|19|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1A|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|1B|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|1C|8|@$M|1D|N|1E|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|F|7|1F|8|@]|9|@]|A|$G|H]]|$1|S|3|T|5|6|7|1G|8|@$M|1H|N|1I|O|P]|$M|1J|N|1K|O|P]|$M|1L|N|1M|O|P]|$M|1N|N|1O|O|P]]|9|@]|A|$]]|$1|U|3|V|5|F|7|1P|8|@]|9|@]|A|$G|H]]|$1|W|3|X|5|6|7|1Q|8|@$M|1R|N|1S|O|P]|$M|1T|N|1U|O|P]]|9|@]|A|$]]|$1|Y|3|Z|5|F|7|1V|8|@]|9|@]|A|$G|H]]|$1|10|3|11|5|6|7|1W|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|1X|8|@$M|1Y|N|1Z|O|P]]|9|@]|A|$]]|$1|14|3|15|5|F|7|20|8|@]|9|@]|A|$G|H]]|$1|16|3|-4|5|6|7|21|8|@]|9|@]|A|$]]]|17|$]]

It looks like this question needs an updated answer.
Limiting the answer to the question title:
<pre><code>where ISNUMERIC(zipcode) = 1
 and zipcode - FLOOR(zipcode) = 0
</code></pre>
Expounding based on the text of the question...
Currently-supported versions of SQL Server all support/include the <code>TRY-CONVERT</code> function.
<pre><code>declare @a varchar(100)
set @a = '-1.2a'
--set @a = '-1.2'
--set @a = '-1'
--set @a = '-1.0'
--set @a = '-0'
--set @a = '0'
--set @a = '1'

select @a as 'Value'
, ISNUMERIC(@a) as ISNUMERIC
, case when ISNUMERIC(@a) = 1 and @a - FLOOR(@a) = 0 then 1 else 0 end as ISINTEGER
, case when try_convert(int, @a) &gt;= 0 and left(@a, 1) &lt;&gt; '-' then 1 else 0 end as ISWHOLENUMBER
, case when try_convert(int, @a) &gt; 0 then 1 else 0 end as ISCOUNTINGNUMBER
</code></pre>
You'll notice that <code>TRY_CONVERT(INT, -1.0)</code> returns <code>NULL</code>. So <code>TRY_CONVERT(INT, @a) IS NOT NULL</code> is not quite right for <code>ISINTEGER</code>.
<pre><code>case when ISNUMERIC(@a) = 1 and @a - FLOOR(@a) = 0 then 1 else 0 end as ISINTEGER
</code></pre>
...works because if <code>ISNUMERIC(@a) = 1</code> is false, <code>FLOOR(@a)</code> is not evaluated. Reversing the order...
<pre><code>case when @a - FLOOR(@a) = 0 and ISNUMERIC(@a) = 1 then 1 else 0 end as ISINTEGER
</code></pre>
...generates an error when the value (@a) is not numeric.
So, for the case of <code>zipcode</code>, assuming you want to verify that a 5-digit zip code is a number and it must be 5 digits (so it can't be zero or less) and would never contain a decimal point (so you don't need to know if 12345.000 is an integer):
<pre><code>where try_convert(int, zipcode) &gt; 0
 and len(zipcode) = 5
</code></pre>

blocks|key|159522|text|也许你应该只以整型数据类型存储整型数据。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|159523|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Maybe you should only store integer data in integer datatypes.

What is the best way to determine whether or not a field's value is an integer in SQL Server (2000/2005/2008)?

IsNumeric returns true for a variety of formats that would not likely convert to an integer. Examples include '15,000' and '15.1'.

You can use a like statement but that only appears to work well for fields that have a pre-determined number of digits...

<pre><code>select * where zipcode like '[0-9][0-9][0-9][0-9][0-9]'
</code></pre>

I could write a user defined function that attempts to convert a varchar parameter to an int within a try/catch block but I'm checking with the community to see if someone has come across any succient methods to achieve this goal - preferably one that can be used within the where clause of a SQL statement without creating other objects.

Best equivalent for IsInteger in SQL Server

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

在SQL Server (2000/2005/2008)中，确定字段值是否为整数的最佳方法是什么？对于可能不会转换为整数的各种格式，IsNumeric将返回true。例如“15,000”和“15.1”。您可以使用like语句，但这似乎只适用于具有预定位数的字段...select * where zipcode like '[0-9][0-9][0-9][0-9][0-9]'我可以编写一个用户定义的

问SQL Server中IsInteger的最佳等价物
EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server中IsInteger的最佳等价物EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server中IsInteger的最佳等价物
EN