declare @s varchar(10) set @s='543f' print case isnumeric(@s) when 1 then cast(@s as int) else 0 end
判断是否是数字 function isNumber(pObj,errMsg){ var obj = eval(pObj); strRef = "1234567890"; if(!isEmpty(pObj,errMsg))return false; for (i=0;i<obj.value.length;i++) { tempChar= obj.value.substring(i,i+1); if (strRef.indexOf(tempChar,0)==-1) { if (errMsg == null || errMsg =="") alert("数据不符合要求,请检查"); else alert(errMsg); if(obj.type=="text") obj.focus(); return false; } } return true; }
print round(rand()*1000000,0)
case isnumeric(str) when 1 then cast(str as int) else 0 end
1、 declare @s varchar(20) set @s='' select case isnumeric(@s) when 0 then 0 else convert(int,@s) end 2、 select convert(int , rand() * (1000000 - 100000) + 100000 )
create function Fn_check (@aa varchar(20)) returns real as begin declare @ss real if isnumeric(@aa) =1 set @ss= @aaelse set @ss=0return @ss end go select dbo.Fn_check('1234') select dbo.Fn_check('12sa34')
set @s='543f'
print case isnumeric(@s) when 1 then cast(@s as int) else 0 end
function isNumber(pObj,errMsg){
var obj = eval(pObj);
strRef = "1234567890";
if(!isEmpty(pObj,errMsg))return false;
for (i=0;i<obj.value.length;i++) {
tempChar= obj.value.substring(i,i+1);
if (strRef.indexOf(tempChar,0)==-1) {
if (errMsg == null || errMsg =="")
alert("数据不符合要求,请检查");
else
alert(errMsg);
if(obj.type=="text")
obj.focus();
return false;
}
}
return true;
}
when 1 then cast(str as int)
else 0
end
declare @s varchar(20)
set @s=''
select case isnumeric(@s) when 0 then 0 else convert(int,@s) end 2、
select convert(int , rand() * (1000000 - 100000) + 100000 )
returns real
as
begin
declare @ss real
if isnumeric(@aa) =1
set @ss= @aaelse
set @ss=0return @ss
end
go
select dbo.Fn_check('1234')
select dbo.Fn_check('12sa34')