{"id":729,"date":"2015-03-11T11:38:22","date_gmt":"2015-03-11T02:38:22","guid":{"rendered":"http:\/\/blog.anyons.net\/?p=729"},"modified":"2022-07-12T14:48:16","modified_gmt":"2022-07-12T05:48:16","slug":"729","status":"publish","type":"post","link":"https:\/\/anyons.net\/?p=729","title":{"rendered":"MSSQL \ud55c\uae00 \uc601\ubb38 \uad6c\ubd84"},"content":{"rendered":"<p>[\ud55c\uae00\uceec\ub7fc\uac12 \ub4e4\uc5b4\uc788\ub294 \uac83\ub9cc \uc9c0\uc6b0\uae30]<\/p>\n<pre class=\"lang:tsql decode:true\">select *\u00a0 from tbl where field like '%[\uac00-\ud7a3]%'\ndelete\u00a0 from tbl where field like '%[\uac00-\ud7a3]%'<\/pre>\n<p>[\uc601\ubb38\uceec\ub7fc\uac12 \ub4e4\uc5b4\uc788\ub294 \uac83\ub9cc \uc9c0\uc6b0\uae30]<\/p>\n<pre class=\"lang:tsql decode:true \">select * from tbl where field like '%[A-Za-z]%'\ndelete from tbl where field like '%[A-Za-z]%'<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>[\ud55c\uae00\uceec\ub7fc\uac12 \ub4e4\uc5b4\uc788\ub294 \uac83\ub9cc \uc9c0\uc6b0\uae30]<\/p>\n<p> select * from tbl where field like &#8216;%[\uac00-\ud7a3]%&#8217; delete from tbl where field like &#8216;%[\uac00-\ud7a3]%&#8217; <\/p>\n<p>[\uc601\ubb38\uceec\ub7fc\uac12 \ub4e4\uc5b4\uc788\ub294 \uac83\ub9cc \uc9c0\uc6b0\uae30]<\/p>\n<p> select * from tbl where field like &#8216;%[A-Za-z]%&#8217; delete from tbl where field like &#8216;%[A-Za-z]%&#8217; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[96],"tags":[110,112],"class_list":["post-729","post","type-post","status-publish","format-standard","hentry","category-programming","tag-database","tag-mssql","odd"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MSSQL \ud55c\uae00 \uc601\ubb38 \uad6c\ubd84 - anydragon<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/anyons.net\/?p=729\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MSSQL \ud55c\uae00 \uc601\ubb38 \uad6c\ubd84 - anydragon\" \/>\n<meta property=\"og:description\" content=\"[\ud55c\uae00\uceec\ub7fc\uac12 \ub4e4\uc5b4\uc788\ub294 \uac83\ub9cc \uc9c0\uc6b0\uae30] select * from tbl where field like &#039;%[\uac00-\ud7a3]%&#039; delete from tbl where field like &#039;%[\uac00-\ud7a3]%&#039; [\uc601\ubb38\uceec\ub7fc\uac12 \ub4e4\uc5b4\uc788\ub294 \uac83\ub9cc \uc9c0\uc6b0\uae30] select * from tbl where field like &#039;%[A-Za-z]%&#039; delete from tbl where field like &#039;%[A-Za-z]%&#039;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/anyons.net\/?p=729\" \/>\n<meta property=\"og:site_name\" content=\"anydragon\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/anydragon\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/anydragon\" \/>\n<meta property=\"article:published_time\" content=\"2015-03-11T02:38:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-12T05:48:16+00:00\" \/>\n<meta name=\"author\" content=\"anydragon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@anydragon\" \/>\n<meta name=\"twitter:site\" content=\"@anydragon\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"anydragon\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=729#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=729\"},\"author\":{\"name\":\"anydragon\",\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"headline\":\"MSSQL \ud55c\uae00 \uc601\ubb38 \uad6c\ubd84\",\"datePublished\":\"2015-03-11T02:38:22+00:00\",\"dateModified\":\"2022-07-12T05:48:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=729\"},\"wordCount\":1,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"keywords\":[\"database\",\"MSSQL\"],\"articleSection\":[\"Programming\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=729#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=729\",\"url\":\"https:\\\/\\\/anyons.net\\\/?p=729\",\"name\":\"MSSQL \ud55c\uae00 \uc601\ubb38 \uad6c\ubd84 - anydragon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#website\"},\"datePublished\":\"2015-03-11T02:38:22+00:00\",\"dateModified\":\"2022-07-12T05:48:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=729#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=729\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=729#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/anyons.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MSSQL \ud55c\uae00 \uc601\ubb38 \uad6c\ubd84\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/anyons.net\\\/#website\",\"url\":\"https:\\\/\\\/anyons.net\\\/\",\"name\":\"anydragon\",\"description\":\"mac, linux, aws, c, c++, mysql, mssql, redis, csharp, nodejs, rust, golang\",\"publisher\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/anyons.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\",\"name\":\"anydragon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"url\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"contentUrl\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"width\":2560,\"height\":1440,\"caption\":\"anydragon\"},\"logo\":{\"@id\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\"},\"sameAs\":[\"http:\\\/\\\/anyons.net\",\"https:\\\/\\\/www.facebook.com\\\/anydragon\",\"https:\\\/\\\/x.com\\\/anydragon\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCr78KWpvmk398vPfpUTWNLg\"],\"url\":\"https:\\\/\\\/anyons.net\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MSSQL \ud55c\uae00 \uc601\ubb38 \uad6c\ubd84 - anydragon","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/anyons.net\/?p=729","og_locale":"ko_KR","og_type":"article","og_title":"MSSQL \ud55c\uae00 \uc601\ubb38 \uad6c\ubd84 - anydragon","og_description":"[\ud55c\uae00\uceec\ub7fc\uac12 \ub4e4\uc5b4\uc788\ub294 \uac83\ub9cc \uc9c0\uc6b0\uae30] select * from tbl where field like '%[\uac00-\ud7a3]%' delete from tbl where field like '%[\uac00-\ud7a3]%' [\uc601\ubb38\uceec\ub7fc\uac12 \ub4e4\uc5b4\uc788\ub294 \uac83\ub9cc \uc9c0\uc6b0\uae30] select * from tbl where field like '%[A-Za-z]%' delete from tbl where field like '%[A-Za-z]%'","og_url":"https:\/\/anyons.net\/?p=729","og_site_name":"anydragon","article_publisher":"https:\/\/www.facebook.com\/anydragon","article_author":"https:\/\/www.facebook.com\/anydragon","article_published_time":"2015-03-11T02:38:22+00:00","article_modified_time":"2022-07-12T05:48:16+00:00","author":"anydragon","twitter_card":"summary_large_image","twitter_creator":"@anydragon","twitter_site":"@anydragon","twitter_misc":{"\uae00\uc4f4\uc774":"anydragon"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/anyons.net\/?p=729#article","isPartOf":{"@id":"https:\/\/anyons.net\/?p=729"},"author":{"name":"anydragon","@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"headline":"MSSQL \ud55c\uae00 \uc601\ubb38 \uad6c\ubd84","datePublished":"2015-03-11T02:38:22+00:00","dateModified":"2022-07-12T05:48:16+00:00","mainEntityOfPage":{"@id":"https:\/\/anyons.net\/?p=729"},"wordCount":1,"commentCount":0,"publisher":{"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"keywords":["database","MSSQL"],"articleSection":["Programming"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/anyons.net\/?p=729#respond"]}]},{"@type":"WebPage","@id":"https:\/\/anyons.net\/?p=729","url":"https:\/\/anyons.net\/?p=729","name":"MSSQL \ud55c\uae00 \uc601\ubb38 \uad6c\ubd84 - anydragon","isPartOf":{"@id":"https:\/\/anyons.net\/#website"},"datePublished":"2015-03-11T02:38:22+00:00","dateModified":"2022-07-12T05:48:16+00:00","breadcrumb":{"@id":"https:\/\/anyons.net\/?p=729#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/anyons.net\/?p=729"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/anyons.net\/?p=729#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/anyons.net\/"},{"@type":"ListItem","position":2,"name":"MSSQL \ud55c\uae00 \uc601\ubb38 \uad6c\ubd84"}]},{"@type":"WebSite","@id":"https:\/\/anyons.net\/#website","url":"https:\/\/anyons.net\/","name":"anydragon","description":"mac, linux, aws, c, c++, mysql, mssql, redis, csharp, nodejs, rust, golang","publisher":{"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/anyons.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":["Person","Organization"],"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b","name":"anydragon","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","url":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","contentUrl":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","width":2560,"height":1440,"caption":"anydragon"},"logo":{"@id":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg"},"sameAs":["http:\/\/anyons.net","https:\/\/www.facebook.com\/anydragon","https:\/\/x.com\/anydragon","https:\/\/www.youtube.com\/channel\/UCr78KWpvmk398vPfpUTWNLg"],"url":"https:\/\/anyons.net\/?author=1"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1784,"url":"https:\/\/anyons.net\/?p=1784","url_meta":{"origin":729,"position":0},"title":"MSSQL Table List Query","author":"anydragon","date":"2020\ub144 08\uc6d4 20\uc77c","format":false,"excerpt":"(10%) select name from sysobjects where type='U' (13%) select * from information_schema.tables (76%) select * from sys.tables","rel":"","context":"&quot;Command&quot;\uc5d0\uc11c","block_context":{"text":"Command","link":"https:\/\/anyons.net\/?cat=93"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1886,"url":"https:\/\/anyons.net\/?p=1886","url_meta":{"origin":729,"position":1},"title":"MSSQL Paging","author":"anydragon","date":"2021\ub144 02\uc6d4 05\uc77c","format":false,"excerpt":"SELECT row_number() OVER(ORDER BY fd_nIdService DESC) AS PagedNumber, * FROM [tb_Service] AS [t] WHERE 1=1 ORDER BY [fd_nIdService] DESC OFFSET ((2 - 1) * 10) ROWS FETCH NEXT 10 ROWS ONLY \u00a0","rel":"","context":"&quot;Programming&quot;\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1931,"url":"https:\/\/anyons.net\/?p=1931","url_meta":{"origin":729,"position":2},"title":"MSSQL History","author":"anydragon","date":"2021\ub144 03\uc6d4 19\uc77c","format":false,"excerpt":"SELECT db_name(st.dbid) DBName , object_schema_name(objectid, st.dbid) SchemaName , object_name(objectid, st.dbid) SPName , qs.total_elapsed_time , creation_time , last_execution_time , text FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.plan_handle)st JOIN sys.dm_exec_cached_plans cp ON qs.plan_handle = cp.plan_handle \u00a0","rel":"","context":"&quot;Programming&quot;\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":228,"url":"https:\/\/anyons.net\/?p=228","url_meta":{"origin":729,"position":3},"title":"mssql alter table column (\ud14c\uc774\ube14 \ud544\ub4dc \uc218\uc815, \uc0ad\uc81c, \ucd94\uac00) \ubc0f \ud14c\uc774\ube14\uba85, \ud544\ub4dc(\uceec\ub7fc)\uba85 \uc218\uc815","author":"anydragon","date":"2011\ub144 12\uc6d4 01\uc77c","format":false,"excerpt":"[\ucd9c\ucc98] MSSQL \ud14c\uc774\ube14\uba85 , \uceec\ub7fc\uba85 \ubc14\uafb8\uae30|\uc791\uc131\uc790 zino1187 1.\ud14c\uc774\ube14\uba85 \ubc14\uafb8\uae30 sp_rename OldTable , NewTable 2.\uceec\ub7fc\uba85 \ubc14\uafb8\uae30 sp_rename 'TableName.OldColumn','TableName.NewColumn' [\ucd9c\ucc98] mssql alter table column\uc791\uc131\uc790 \uc7ac\uc6d0\ub9e8 1. \ud14c\uc774\ube14 \ud544\ub4dc \uc218\uc815\ud558\uae30 alter table sale alter column title varchar(200) not null 2. \ud544\ub4dc \uc0ad\uc81c\ud558\uae30 alter table sale drop title 3. \ud544\ub4dc \ucd94\uac00\ud558\uae30 alter table sal\u2026","rel":"","context":"&quot;Command&quot;\uc5d0\uc11c","block_context":{"text":"Command","link":"https:\/\/anyons.net\/?cat=93"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":18,"url":"https:\/\/anyons.net\/?p=18","url_meta":{"origin":729,"position":4},"title":"OLE DB\ub85c oracle\uc774\uac74 MSSQL\uc774\uac74 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uae30 \uc704\ud55c \uae30\ucd08 \ucf54\ub4dc","author":"anydragon","date":"2009\ub144 10\uc6d4 09\uc77c","format":false,"excerpt":"private OleDbDataReader rd; private OleDbConnection Conn; private string strRet; private OleDbCommand cmd; private StringBuilder sbSQL; private OleDbParameter paramnSeq; try { \/\/ SQLOLEDB MSDAORA Conn = new OleDbConnection(\"Provider=MSDAORA;Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.xxx )(PORT = 1521)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = GROUP))); User Id =;\u2026","rel":"","context":"&quot;Programming&quot;\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1928,"url":"https:\/\/anyons.net\/?p=1928","url_meta":{"origin":729,"position":5},"title":"\ud1b5\uacc4\uc6a9 \ucffc\ub9ac \uc0d8\ud50c","author":"anydragon","date":"2021\ub144 03\uc6d4 18\uc77c","format":false,"excerpt":"select year as '\ub144', month as '\uc6d4', count(*) as count from ( select YEAR(us.fd_dtcreate) as 'year', MONTH(us.fd_dtcreate) as 'month' from tb_ykfile as us where us.fd_dtCreate > '2020-08-01' and us.fd_dtCreate <= '2022-01-01' ) tb group by year, month order by year, month ; SELECT CONVERT(varCHAR(10),Dateadd(d, a.number,'2020-08-01 00:00:00'),120) AS dt ,Isnull(b.count, 0)\u2026","rel":"","context":"&quot;Programming&quot;\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts\/729","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=729"}],"version-history":[{"count":0,"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts\/729\/revisions"}],"wp:attachment":[{"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}