_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › Whereろ

Contents

1 1:
2 2:


螳 where ろ 伎 覓至海. 覓詞襷螻 覲 蟆 企. ろ 豌 螳.

1 1: #

;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()襦 覲讌 覈詩給.
*/

2 2: #

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 -- 襯 覦蠖
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:53

螳讌襷 . (W. 觚危)