本文介绍了在SQL Server中将varchar转换为bigint时发生转换错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
HI,
select ISNUMERIC('149972,') out put: 1 select ISNUMERIC('149972=')
out put: 0
在这里先出来显示1,然后再出来显示0 是吗,是否也包含在int中 谢谢 ramesh.m
here in first out put it show 1 and second out put it show 0 is it , is also include in int or not Thanks ramesh.m
推荐答案根据MSDN上的定义:当输入表达式计算为有效数值数据类型时,ISNUMERIC返回1.有效数值数据类型包括以下内容: int,数值,bigint,货币,smallint,smallmoney,tinyint,浮点数,十进制,实数" Money中允许使用逗号,因此它返回1.如果在输入中加上+,-£等,它也会返回1. msdn.microsoft/en-us/library/ms186272.aspx [ ^ ] 希望能有所帮助.如果是这样,请将其标记为答案/赞. 谢谢 Milind According to definition on MSDN: "ISNUMERIC returns 1 when the input expression evaluates to a valid numeric data type. Valid numeric data types include the following: int, numeric, bigint, money, smallint, smallmoney, tinyint, float, decimal, real" Comma is allowed in Money, hence it is returning 1. It will also return 1 if you +, - £ etc signs in the input. msdn.microsoft/en-us/library/ms186272.aspx[^] Hope that helps. If it does, mark it as answer/upvote. Thanks Milind
报价:msdn.microsoft/en-us/library/ms186272.aspx [ ^ ]
当输入表达式的计算结果为有效的数值数据类型时,ISNUMERIC返回1;否则返回0.
ISNUMERIC returns 1 when the input expression evaluates to a valid numeric data type; otherwise it returns 0.
表达式中的"="使其成为无效的数字.
The ''='' in the expression makes it a invalid numeric.
更多推荐
在SQL Server中将varchar转换为bigint时发生转换错误
发布评论