{"id":148,"date":"2022-01-06T11:44:23","date_gmt":"2022-01-06T03:44:23","guid":{"rendered":"http:\/\/www.bigqq.com\/?p=148"},"modified":"2022-01-06T11:49:22","modified_gmt":"2022-01-06T03:49:22","slug":"sql%e6%95%88%e7%8e%87","status":"publish","type":"post","link":"http:\/\/www.bigqq.com\/?p=148","title":{"rendered":"sql\u6548\u7387"},"content":{"rendered":"\n<p>OPTION(RECOMPILE) \u53ef\u4ee5\u4e0d\u4fdd\u5b58\u8ba1\u5212\u7f13\u5b58\uff0c\u6bcf\u6b21\u91cd\u65b0\u89e3\u6790\uff0c\u5bf9\u4e00\u4e9b\u5305\u542b\u53c2\u6570\u6761\u4ef6\u7684sql\u53ef\u4ee5\u63d0\u4f9b\u6548\u7387<\/p>\n\n\n\n<p>Like\u4e0echarindex, patindex \uff0c\u5168\u5c40\u6a21\u7cca \uff08&#8217;%123%&#8217;\uff09 \u4e00\u822ccharindex\u6548\u7387\u8f83\u9ad8\uff0c\u5982\u90e8\u5206\u5339\u914d\uff08&#8217;123%&#8217;\uff09Like\u53ef\u80fd\u6548\u7387\u9ad8<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"\"><tbody><tr><td>&nbsp;<\/td><td>\u6b63\u5219\u5339\u914d<\/td><td>\u9009\u62e9\u5f00\u59cb\u4f4d\u7f6e<\/td><td>\u652f\u6301\u7d22\u5f15\u67e5\u627e<\/td><\/tr><tr><td>like<\/td><td>\u53ef\u4ee5<\/td><td>\u4e0d\u53ef\u4ee5<\/td><td>\u90e8\u5206\u53ef\u4ee5<\/td><\/tr><tr><td>charindex<\/td><td>\u4e0d\u53ef\u4ee5<\/td><td>\u53ef\u4ee5<\/td><td>\u4e0d\u53ef\u4ee5<\/td><\/tr><tr><td>patindex<\/td><td>\u53ef\u4ee5<\/td><td>\u4e0d\u53ef\u4ee5<\/td><td>\u4e0d\u53ef\u4ee5<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>OPTION(RECOMPILE) \u53ef\u4ee5 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/posts\/148"}],"collection":[{"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=148"}],"version-history":[{"count":4,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/posts\/148\/revisions"}],"predecessor-version":[{"id":152,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/posts\/148\/revisions\/152"}],"wp:attachment":[{"href":"http:\/\/www.bigqq.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=148"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}