17:["$","div",null,{"id":"container","children":[["$","div",null,{"id":"container2","children":[["$","div",null,{"id":"container3","children":[["$","div",null,{"id":"header","children":[["$","div",null,{"id":"banner","children":[["$","h1",null,{"children":["$","a",null,{"href":"https://sendohlun.pixnet.net/blog","children":"廣度與深度"}]}],["$","p",null,{"className":"skiplink","children":["$","a",null,{"href":"#article-area","title":"skip the page header to the main content","children":"跳到主文"}]}],["$","h2",null,{"suppressHydrationWarning":true,"dangerouslySetInnerHTML":{"__html":"心情/育兒/財經/創業\r\n\r\n登高必自卑，行遠必自邇\r\n千里之行，始於足下\r\n\r\n面對訊息萬變的現今社會，太多思緒需要整理。\r\n要能廣泛涉獵各個領域，才能客觀的去看待事物，\r\n對於每個議題也該深入去探討，才能有效洞悉結論。\r\n\r\n記錄每日所思，是第一步。"}}],["$","p",null,{"id":"blog-category","children":["部落格全站分類：",["$","a",null,{"href":"#","children":"心情日記"}]]}]]}],["$","ul",null,{"id":"navigation","children":[["$","li",null,{"className":"navigation-links","id":"link-album","children":["$","a",null,{"href":"/albums","title":"go to gallery page of this user","children":"相簿"}]}],["$","li",null,{"className":"navigation-links","id":"link-blog","children":["$","a",null,{"href":"https://sendohlun.pixnet.net/blog","title":"go to index page of this blog","children":"部落格"}]}],["$","li",null,{"className":"navigation-links","id":"link-guestbook","children":["$","a",null,{"id":"guestbook","data-msg":"尚未安裝留言板，無法進行留言","data-action":"none","href":"#","title":"go to guestbook page of this user","children":"留言"}]}],["$","li",null,{"className":"navigation-links","id":"link-profile","children":["$","a",null,{"href":"https://www.pixnet.net/pcard/4164141","title":"go to profile page of this user","children":"名片"}]}]]}]]}],["$","div",null,{"id":"main","children":[["$","div",null,{"id":"content","children":["$","div",null,{"id":"article-area","children":["$","div",null,{"id":"article-box","children":["$","div",null,{"className":"article","children":[["$","ul",null,{"className":"article-head","children":[["$","li",null,{"className":"publish","children":[["$","span",null,{"className":"month","children":["3月"," "]}],["$","span",null,{"className":"date","children":["20"," "]}],["$","span",null,{"className":"day","children":["週五"," "]}],["$","span",null,{"className":"year","children":"2015"}],["$","span",null,{"className":"time","children":"17:18"}]]}],["$","li",null,{"className":"title","id":"article-9414703213","data-site-category":"進修深造","data-site-category-id":8,"data-article-link":"https://sendohlun.pixnet.net/blog/posts/9414703213","children":["$","h2",null,{"children":["$","a",null,{"href":"https://sendohlun.pixnet.net/blog/posts/9414703213","children":"[SQL]查詢某欄位裡面的字串長度"}]}]}]]}],["$","div",null,{"className":"article-body","children":[["$","div",null,{"className":"article-content","children":[["$","div",null,{"className":"article-content-inner","id":"article-content-inner","suppressHydrationWarning":true,"dangerouslySetInnerHTML":{"__html":"

MS SQL 查詢某欄位裡面的字串長度

\r\n

Select len(ColumnName),ColumnName From TableName

\r\n

order by len(ColumnName) desc

"}}],["$","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/sendohlun/logo/sendohlun.png","alt":"創作者 sendohlun 的頭像","loading":"lazy"}]}],"$L1c","$L1d","$L1e"]}]]}]]}],"$L1f","$L20"]}],"$L21","$L22"]}]}]}]}],"$L23"]}],"$L24"]}],"$L25","$L26","$L27","$L28"]}],"$L29","$L2a","$L2b","$L2c"]}]

廣度與深度

[SQL]查詢某欄位裡面的字串長度

個人資訊

熱門文章

文章分類

最新文章

最新留言

動態訂閱

文章精選

文章搜尋

誰來我家

參觀人氣