{"id":228,"date":"2011-12-01T05:42:03","date_gmt":"2011-12-01T05:42:03","guid":{"rendered":"http:\/\/anyons.net\/dev\/?p=228"},"modified":"2022-07-12T14:49:02","modified_gmt":"2022-07-12T05:49:02","slug":"mssql-alter-table-column-%ed%85%8c%ec%9d%b4%eb%b8%94-%ed%95%84%eb%93%9c-%ec%88%98%ec%a0%95-%ec%82%ad%ec%a0%9c-%ec%b6%94%ea%b0%80-%eb%b0%8f-%ed%85%8c%ec%9d%b4%eb%b8%94%eb%aa%85-%ed%95%84%eb%93%9c","status":"publish","type":"post","link":"https:\/\/anyons.net\/?p=228","title":{"rendered":"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"},"content":{"rendered":"<p>[\ucd9c\ucc98] <a href=\"http:\/\/blog.naver.com\/zino1187\/110033914807\" target=\"_blank\" rel=\"noopener\">MSSQL \ud14c\uc774\ube14\uba85 , \uceec\ub7fc\uba85 \ubc14\uafb8\uae30<\/a>|\uc791\uc131\uc790 <a href=\"http:\/\/blog.naver.com\/zino1187\" target=\"_blank\" rel=\"noopener\">zino1187<\/a><\/p>\n<p>1.\ud14c\uc774\ube14\uba85 \ubc14\uafb8\uae30<\/p>\n<pre class=\"lang:tsql decode:true\">sp_rename OldTable , NewTable<\/pre>\n<p>2.\uceec\ub7fc\uba85 \ubc14\uafb8\uae30<\/p>\n<pre class=\"lang:tsql decode:true\">sp_rename 'TableName.OldColumn','TableName.NewColumn'<\/pre>\n<p>[\ucd9c\ucc98] <a href=\"http:\/\/blog.naver.com\/jaewonman\/100034374765\" target=\"_blank\" rel=\"noopener\">mssql alter table column<\/a>\uc791\uc131\uc790 <a href=\"http:\/\/blog.naver.com\/jaewonman\" target=\"_blank\" rel=\"noopener\">\uc7ac\uc6d0\ub9e8<\/a><\/p>\n<p>1. \ud14c\uc774\ube14 \ud544\ub4dc \uc218\uc815\ud558\uae30<\/p>\n<pre class=\"lang:tsql decode:true\">alter table sale alter column title varchar(200) not null<\/pre>\n<p>2. \ud544\ub4dc \uc0ad\uc81c\ud558\uae30<\/p>\n<pre class=\"lang:tsql decode:true\">alter table sale drop title<\/pre>\n<p>3. \ud544\ub4dc \ucd94\uac00\ud558\uae30<\/p>\n<pre class=\"lang:tsql decode:true\">alter table sal add sale varchar(20) not null\nalter table sale add isDel bit DEFAULT 0 not null<\/pre>\n\n","protected":false},"excerpt":{"rendered":"<p>[\ucd9c\ucc98] MSSQL \ud14c\uc774\ube14\uba85 , \uceec\ub7fc\uba85 \ubc14\uafb8\uae30|\uc791\uc131\uc790 zino1187<\/p>\n<p>1.\ud14c\uc774\ube14\uba85 \ubc14\uafb8\uae30<\/p>\n<p> sp_rename OldTable , NewTable <\/p>\n<p>2.\uceec\ub7fc\uba85 \ubc14\uafb8\uae30<\/p>\n<p> sp_rename &#8216;TableName.OldColumn&#8217;,&#8217;TableName.NewColumn&#8217; <\/p>\n<p>[\ucd9c\ucc98] mssql alter table column\uc791\uc131\uc790 \uc7ac\uc6d0\ub9e8<\/p>\n<p>1. \ud14c\uc774\ube14 \ud544\ub4dc \uc218\uc815\ud558\uae30<\/p>\n<p> alter table sale alter column title varchar(200) not null <\/p>\n<p>2. \ud544\ub4dc \uc0ad\uc81c\ud558\uae30<\/p>\n<p> alter table sale drop title <\/p>\n<p>3. \ud544\ub4dc \ucd94\uac00\ud558\uae30<\/p>\n<p> alter table sal add sale varchar(20) not null [&#8230;]<\/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":[93,96],"tags":[264,223,112,103,177],"class_list":["post-228","post","type-post","status-publish","format-standard","hentry","category-command","category-programming","tag-alter","tag-column","tag-mssql","tag-sql","tag-table","odd"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<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 - 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=228\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"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 - anydragon\" \/>\n<meta property=\"og:description\" content=\"[\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 &#039;TableName.OldColumn&#039;,&#039;TableName.NewColumn&#039; [\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 add sale varchar(20) not null [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/anyons.net\/?p=228\" \/>\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=\"2011-12-01T05:42:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-12T05:49:02+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=228#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=228\"},\"author\":{\"name\":\"anydragon\",\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"headline\":\"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\",\"datePublished\":\"2011-12-01T05:42:03+00:00\",\"dateModified\":\"2022-07-12T05:49:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=228\"},\"wordCount\":10,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"keywords\":[\"alter\",\"column\",\"MSSQL\",\"sql\",\"table\"],\"articleSection\":[\"Command\",\"Programming\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=228#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=228\",\"url\":\"https:\\\/\\\/anyons.net\\\/?p=228\",\"name\":\"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 - anydragon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#website\"},\"datePublished\":\"2011-12-01T05:42:03+00:00\",\"dateModified\":\"2022-07-12T05:49:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=228#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=228\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=228#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/anyons.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"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\"}]},{\"@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 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 - 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=228","og_locale":"ko_KR","og_type":"article","og_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 - anydragon","og_description":"[\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 add sale varchar(20) not null [...]","og_url":"https:\/\/anyons.net\/?p=228","og_site_name":"anydragon","article_publisher":"https:\/\/www.facebook.com\/anydragon","article_author":"https:\/\/www.facebook.com\/anydragon","article_published_time":"2011-12-01T05:42:03+00:00","article_modified_time":"2022-07-12T05:49:02+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=228#article","isPartOf":{"@id":"https:\/\/anyons.net\/?p=228"},"author":{"name":"anydragon","@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"headline":"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","datePublished":"2011-12-01T05:42:03+00:00","dateModified":"2022-07-12T05:49:02+00:00","mainEntityOfPage":{"@id":"https:\/\/anyons.net\/?p=228"},"wordCount":10,"commentCount":0,"publisher":{"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"keywords":["alter","column","MSSQL","sql","table"],"articleSection":["Command","Programming"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/anyons.net\/?p=228#respond"]}]},{"@type":"WebPage","@id":"https:\/\/anyons.net\/?p=228","url":"https:\/\/anyons.net\/?p=228","name":"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 - anydragon","isPartOf":{"@id":"https:\/\/anyons.net\/#website"},"datePublished":"2011-12-01T05:42:03+00:00","dateModified":"2022-07-12T05:49:02+00:00","breadcrumb":{"@id":"https:\/\/anyons.net\/?p=228#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/anyons.net\/?p=228"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/anyons.net\/?p=228#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/anyons.net\/"},{"@type":"ListItem","position":2,"name":"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"}]},{"@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":228,"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":267,"url":"https:\/\/anyons.net\/?p=267","url_meta":{"origin":228,"position":1},"title":"ms sql \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \ubcf5\uc6d0\ubc29\ubc95","author":"anydragon","date":"2012\ub144 02\uc6d4 14\uc77c","format":false,"excerpt":"\ucd9c\ucc98 : http:\/\/nextstep.co.kr\/105 -- \ubc31\uc5c5\uc0dd\uc131(\uc788\uc73c\uba74 \uc0dd\ub7b5) BACKUP DATABASE Northwind TO DISK = 'c:\\Northwind.bak' --\ubc31\uc5c5\uc815\ubcf4\ud655\uc778(\ub17c\ub9ac\uc801\ud30c\uc77c\uba85, \ubb3c\ub9ac\uc801\uc800\uc7a5\uc704\uce58\ubc0f\ud30c\uc77c\uba85 \ud655\uc778) RESTORE FILELISTONLY FROM DISK = 'c:\\Northwind.bak' -- TestDB\ub77c\ub294 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \uc0c8\ub85c\uc6b4 \uacbd\ub85c(C:\\temptest*.*)\uc73c\ub85c \ubcf5\uc6d0 RESTORE DATABASE TestDB FROM DISK = 'c:\\Northwind.bak' WITH MOVE 'Northwind' TO 'c:\\testtestdb.mdf', MOVE 'Northwind_log' TO 'c:\\testtestdb.ldf'","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":228,"position":2},"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":630,"url":"https:\/\/anyons.net\/?p=630","url_meta":{"origin":228,"position":3},"title":"table \uc874\uc7ac \uc548\ud560\ub54c table \uc0dd\uc131","author":"anydragon","date":"2014\ub144 02\uc6d4 14\uc77c","format":false,"excerpt":"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';","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":228,"position":4},"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":2346,"url":"https:\/\/anyons.net\/?p=2346","url_meta":{"origin":228,"position":5},"title":"EF \ub0b4\uc5d0 ForeignKey \uad6c\uc131\uc5d0 \ub530\ub978 \uc2a4\ud0a4\ub9c8 \uc0dd\uc131","author":"anydragon","date":"2021\ub144 04\uc6d4 19\uc77c","format":false,"excerpt":"ICollection \uc0ac\uc6a9 public ICollection<Student> m_listLandSiteDataText { get; set; } protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AddColumn<int>( name: \"CourseId\", table: \"Students\", nullable: true); migrationBuilder.CreateIndex( name: \"IX_Students_CourseId\", table: \"Students\", column: \"CourseId\"); migrationBuilder.AddForeignKey( name: \"FK_Students_Courses_CourseId\", table: \"Students\", column: \"CourseId\", principalTable: \"Courses\", principalColumn: \"CourseId\", onDelete: ReferentialAction.Restrict); } Index\uc640 ForeignKey \uc5c6\uc774 \uc0dd\uc131 [ForeignKey(\"Course\")] public int\u2026","rel":"","context":"&quot;Concept&quot;\uc5d0\uc11c","block_context":{"text":"Concept","link":"https:\/\/anyons.net\/?cat=95"},"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\/228","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=228"}],"version-history":[{"count":0,"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts\/228\/revisions"}],"wp:attachment":[{"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}