15:["$","div",null,{"className":"article-content","children":[["$","div",null,{"className":"article-content-inner","id":"article-content-inner","suppressHydrationWarning":true,"dangerouslySetInnerHTML":{"__html":"\n需要在sql的where條件子句中過濾特定的條件判斷

例如:輸入空白時,該欄位將不進行條件的判斷

以下的例子,想找出在台灣的某都市中,該區的一些資訊
如果區的條件輸入空白時則略過該條件判斷

WHERE country = 'Taiwan' AND city_no = @city_no AND
area_no LIKE
CASE WHEN ISNULL(@area_no,'') <> '' THEN
@area_no
ELSE
'%' + @area_no
END
"}}],["$","div",null,{"className":"tag-container-parent","children":[["$","div",null,{"className":"tag-container article-keyword","data-version":"a","children":[["$","div",null,{"className":"tag__header","children":["$","div",null,{"className":"tag__header-title","children":"文章標籤"}]}],["$","div",null,{"className":"tag__main","id":"article-footer-tags","children":[]}]]}],["$","div",null,{"className":"tag-container global-keyword","children":[["$","div",null,{"className":"tag__header","children":["$","div",null,{"className":"tag__header-title","children":"全站熱搜"}]}],["$","div",null,{"className":"tag__main","children":[]}]]}]]}],["$","div",null,{"className":"author-profile","children":[["$","div",null,{"className":"author-profile__header","children":"創作者介紹"}],["$","div",null,{"className":"author-profile__main","id":"mixpanel-author-box","children":[["$","a",null,{"children":["$","img",null,{"className":"author-profile__avatar","src":"https://pimg.1px.tw/wthomasu/logo/wthomasu.png","alt":"創作者湯瑪的吳的頭像","loading":"lazy"}]}],["$","div",null,{"className":"author-profile__content","children":[["$","a",null,{"className":"author-profile__name","children":"湯瑪的吳"}],["$","p",null,{"className":"author-profile__info","children":"安達利機車行"}]]}],["$","div",null,{"className":"author-profile__subscribe hoverable","children":["$","button",null,{"data-follow-state":"關注","className":"subscribe-btn member"}]}]]}]]}]]}]

安達利機車行

曾經是一間在台南府前路上的機車行 ~

[SQL] WHERE條件中的if判斷

個人資訊

文章精選

文章分類

最新文章

熱門文章

最新留言

動態訂閱

文章搜尋

誰來我家

參觀人氣