螳 where ろ 伎 覓至海. 覓詞襷螻 覲 蟆 企. ろ 豌 螳.
;with temp
as
(
select '1' num
union all
select 'null'
)
select *
from temp
where 1=1
and convert(int, num) > 0
and isnumeric(num) = 1
/*
覃讌 245, 譴 16, 1, 譴 2
varchar 螳 'null'(襯) 一危 int()襦 覲讌 覈詩給.
*/
where 譟郁唄れ 襯 覦蠖.
;with temp
as
(
select '1' num
union all
select 'null'
)
select *
from temp
where 1=1
and isnumeric(num) = 1 -- 襯 覦蠖
and convert(int, num) > 0 -- 襯 覦蠖