cnblogs/dcrenl/SQL判断字符类型是否为数字(1).html
2024-09-24 12:43:01 +08:00

20 lines
620 B
HTML
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<div id="sina_keyword_ad_area2" class="articalContent "> <span style="color: #ff0000;">用ISNUMERIC函数<br />
<br />
确定表达式是否为一个有效的数字类型。<br />
<br />
语法<br />
ISNUMERIC ( expression )<br />
<br />
参数<br />
expression<br />
<br />
要计算的表达式。<br />
<br />
返回类型<br />
int<br />
<br />
注释<br />
当输入表达式得数为一个有效的整数、浮点数、money 或 decimal 类型,那么 ISNUMERIC 返回 1否则返回
0。返回值为 1 确保可以将 expression 转换为上述数字类型中的一种。</span>
</div>
<p>&nbsp;</p>