{"id":630,"date":"2014-02-14T04:14:19","date_gmt":"2014-02-14T04:14:19","guid":{"rendered":"http:\/\/dev.anyons.net\/?p=630"},"modified":"2022-07-12T14:48:24","modified_gmt":"2022-07-12T05:48:24","slug":"db-%ec%a1%b4%ec%9e%ac-%ec%95%88%ed%95%a0%eb%95%8c-db-%ec%83%9d%ec%84%b1","status":"publish","type":"post","link":"https:\/\/anyons.net\/?p=630","title":{"rendered":"table \uc874\uc7ac \uc548\ud560\ub54c table \uc0dd\uc131"},"content":{"rendered":"<pre class=\"lang:tsql decode:true\">drop \n  table tempdb;\nif exists (\n  select \n    * \n  from \n    sysobjects \n  where \n    name = 'tempdb' \n    and xtype = 'U'\n) create table cars111 (\n  Name0 varchar(64) not null, \n  Name1 varchar(64) not null, \n  Name2 varchar(64) not null\n);\nselect \n  * \nfrom \n  INFORMATION_SCHEMA.COLUMNS \nwhere \n  table_name = 'cars111' \n  and column_name = 'Name0';\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>drop table tempdb; if exists ( select * from sysobjects where name = &#8216;tempdb&#8217; and xtype = &#8216;U&#8217; ) create table cars111 ( Name0 varchar(64) not null, Name1 varchar(64) not null, Name2 varchar(64) not null ); select * from INFORMATION_SCHEMA.COLUMNS where table_name = &#8216;cars111&#8217; and column_name = &#8216;Name0&#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":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[96,165],"tags":[110,178,103,177],"class_list":["post-630","post","type-post","status-publish","format-standard","hentry","category-programming","category-system","tag-database","tag-exist","tag-sql","tag-table","odd"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>table \uc874\uc7ac \uc548\ud560\ub54c table \uc0dd\uc131 - 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=630\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"table \uc874\uc7ac \uc548\ud560\ub54c table \uc0dd\uc131 - anydragon\" \/>\n<meta property=\"og:description\" content=\"drop table tempdb; if exists ( select * from sysobjects where name = &#039;tempdb&#039; and xtype = &#039;U&#039; ) create table cars111 ( Name0 varchar(64) not null, Name1 varchar(64) not null, Name2 varchar(64) not null ); select * from INFORMATION_SCHEMA.COLUMNS where table_name = &#039;cars111&#039; and column_name = &#039;Name0&#039;;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/anyons.net\/?p=630\" \/>\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=\"2014-02-14T04:14:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-12T05:48:24+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=630#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=630\"},\"author\":{\"name\":\"anydragon\",\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"headline\":\"table \uc874\uc7ac \uc548\ud560\ub54c table \uc0dd\uc131\",\"datePublished\":\"2014-02-14T04:14:19+00:00\",\"dateModified\":\"2022-07-12T05:48:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=630\"},\"wordCount\":2,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"keywords\":[\"database\",\"exist\",\"sql\",\"table\"],\"articleSection\":[\"Programming\",\"System\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=630#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=630\",\"url\":\"https:\\\/\\\/anyons.net\\\/?p=630\",\"name\":\"table \uc874\uc7ac \uc548\ud560\ub54c table \uc0dd\uc131 - anydragon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#website\"},\"datePublished\":\"2014-02-14T04:14:19+00:00\",\"dateModified\":\"2022-07-12T05:48:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=630#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=630\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=630#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/anyons.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"table \uc874\uc7ac \uc548\ud560\ub54c table \uc0dd\uc131\"}]},{\"@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":"table \uc874\uc7ac \uc548\ud560\ub54c table \uc0dd\uc131 - 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=630","og_locale":"ko_KR","og_type":"article","og_title":"table \uc874\uc7ac \uc548\ud560\ub54c table \uc0dd\uc131 - anydragon","og_description":"drop table tempdb; if exists ( select * from sysobjects where name = 'tempdb' and xtype = 'U' ) create table cars111 ( Name0 varchar(64) not null, Name1 varchar(64) not null, Name2 varchar(64) not null ); select * from INFORMATION_SCHEMA.COLUMNS where table_name = 'cars111' and column_name = 'Name0';","og_url":"https:\/\/anyons.net\/?p=630","og_site_name":"anydragon","article_publisher":"https:\/\/www.facebook.com\/anydragon","article_author":"https:\/\/www.facebook.com\/anydragon","article_published_time":"2014-02-14T04:14:19+00:00","article_modified_time":"2022-07-12T05:48:24+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=630#article","isPartOf":{"@id":"https:\/\/anyons.net\/?p=630"},"author":{"name":"anydragon","@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"headline":"table \uc874\uc7ac \uc548\ud560\ub54c table \uc0dd\uc131","datePublished":"2014-02-14T04:14:19+00:00","dateModified":"2022-07-12T05:48:24+00:00","mainEntityOfPage":{"@id":"https:\/\/anyons.net\/?p=630"},"wordCount":2,"commentCount":0,"publisher":{"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"keywords":["database","exist","sql","table"],"articleSection":["Programming","System"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/anyons.net\/?p=630#respond"]}]},{"@type":"WebPage","@id":"https:\/\/anyons.net\/?p=630","url":"https:\/\/anyons.net\/?p=630","name":"table \uc874\uc7ac \uc548\ud560\ub54c table \uc0dd\uc131 - anydragon","isPartOf":{"@id":"https:\/\/anyons.net\/#website"},"datePublished":"2014-02-14T04:14:19+00:00","dateModified":"2022-07-12T05:48:24+00:00","breadcrumb":{"@id":"https:\/\/anyons.net\/?p=630#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/anyons.net\/?p=630"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/anyons.net\/?p=630#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/anyons.net\/"},{"@type":"ListItem","position":2,"name":"table \uc874\uc7ac \uc548\ud560\ub54c table \uc0dd\uc131"}]},{"@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":228,"url":"https:\/\/anyons.net\/?p=228","url_meta":{"origin":630,"position":0},"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":270,"url":"https:\/\/anyons.net\/?p=270","url_meta":{"origin":630,"position":1},"title":"SQL Injection \ubc29\uc5b4","author":"anydragon","date":"2012\ub144 02\uc6d4 20\uc77c","format":false,"excerpt":"\ucd9c\ucc98 : http:\/\/forums.asp.net\/t\/1254125.aspx \ub97c \ubcf4\uba74 ASP.NET 1.1\uc774\ub0d0 2.0 \uc774\ub0d0\uc5d0 \ub530\ub77c \uac01\uac01 \uc774\ub807\uac8c \ud558\ub77c\uace0 \ud55c\ub2e4. \uc544\uc9c1\uc740 \ub09c web.config\uac00 \uc775\uc219\uce58 \uc54a\uc544\uc11c \uadf8\ub7f0\uc9c0 1.1 \ubc29\uc2dd\uc73c\ub85c \ud558\uba74 \uc798 \ub418\ub294\ub370 2.0 \ubc29\uc2dd\uc73c\ub85c\ub294 \uc798 \uc548\ub41c\ub2e4. -_- ASP.NET 1.1 C# global.asax using System.Globalization; \/\/Defines the set of characters that will be checked. \/\/You can add to this\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":630,"position":2},"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":[]},{"id":1266,"url":"https:\/\/anyons.net\/?p=1266","url_meta":{"origin":630,"position":3},"title":"mybatis.net \uc790\ub8cc\ud615","author":"anydragon","date":"2017\ub144 02\uc6d4 17\uc77c","format":false,"excerpt":"CLR Type Object\/Map Property Mapping Result Class\/Parameter Class** Type Alias** System.ArrayList Yes Yes list System.Boolean Yes Yes Boolean, bool System.Byte Yes Yes Byte, byte System.Char Yes Yes Char, char System.DateTime Yes Yes dateTime, date System.Decimal Yes Yes Decimal, decimal System.Double Yes Yes Double, double System.Guid Yes Yes guid System.Hashtable Yes\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":2580,"url":"https:\/\/anyons.net\/?p=2580","url_meta":{"origin":630,"position":4},"title":"bootstrap\uc5d0\uc11c bootstrap-select \uc0ac\uc6a9\ud560\ub54c \uc0c1\uc704\uc5d0 \uc788\ub294 table-responsive\ub54c\ubb38\uc5d0 dropdown\uc774 \uc9e4\ub824 \ubcf4\uc77c\ub54c \uc0ac\uc6a9\ud558\ub294 css","author":"anydragon","date":"2022\ub144 06\uc6d4 15\uc77c","format":false,"excerpt":".css \/* table-responsive\uc758 \ub192\uc774\uac00 \uc9e7\uc744\ub54c dropdown-menu\uac00 \uc9e4\ub9ac\ub294 \ubb38\uc81c \ud574\uacb0 *\/ @media (max-width: 767px) { .table-responsive .dropdown-menu { position: static !important; } } \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":1784,"url":"https:\/\/anyons.net\/?p=1784","url_meta":{"origin":630,"position":5},"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":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts\/630","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=630"}],"version-history":[{"count":0,"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts\/630\/revisions"}],"wp:attachment":[{"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}