{"id":18,"date":"2009-10-09T10:17:51","date_gmt":"2009-10-09T10:17:51","guid":{"rendered":"http:\/\/anyons.net\/dev\/?p=18"},"modified":"2022-07-12T14:49:28","modified_gmt":"2022-07-12T05:49:28","slug":"ole-db%eb%a1%9c-oracle%ec%9d%b4%ea%b1%b4-mssql%ec%9d%b4%ea%b1%b4-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%a5%bc-%ea%b0%80%ec%a0%b8%ec%98%a4%ea%b8%b0-%ec%9c%84%ed%95%9c-%ea%b8%b0%ec%b4%88-%ec%bd%94%eb%93%9c","status":"publish","type":"post","link":"https:\/\/anyons.net\/?p=18","title":{"rendered":"OLE DB\ub85c oracle\uc774\uac74 MSSQL\uc774\uac74 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uae30 \uc704\ud55c \uae30\ucd08 \ucf54\ub4dc"},"content":{"rendered":"\n
private OleDbDataReader rd;\nprivate OleDbConnection Conn;\nprivate string strRet;\nprivate OleDbCommand cmd;\nprivate StringBuilder sbSQL;\nprivate OleDbParameter paramnSeq;\n\ntry\n{\n\t\/\/ SQLOLEDB MSDAORA\n\tConn = 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 =; Password =;\");\n\tConn.Open();\n\n\ttry\n\t{\n\t\tsbSQL = new StringBuilder();\n\n\t\tsbSQL.Append(\" SELECT * \");\n\t\tsbSQL.Append(\" FROM HEIS_CUSTOMER \");\n\t\tsbSQL.Append(\" WHERE 1=1 \");\n\t\tsbSQL.Append(\" AND CUSTOMER_CODE = ? \");\n\n\t\tparamnSeq = new OleDbParameter(\"CUSTOMER_CODE\", OleDbType.Char, 4);\n\t\tparamnSeq.Value = \"0003\";\n\n\t\tcmd = new OleDbCommand(sbSQL.ToString(), Conn);\n\t\tcmd.Parameters.Add(paramnSeq);\n\n\t\trd = cmd.ExecuteReader();\n\n\t\tif (rd.Read())\n\t\t{\n\t\t\tstrRet = rd[\"CUSTOMER_CODE\"].ToString();\n\t\t}\n\t\telse\n\t\t{\n\t\t\tstrRet = \"\";\n\t\t}\n\t}\n\tcatch (System.Exception e1)\n\t{\n\t\tthrow e1;\n\t}\n\tfinally\n\t{\n\t\trd.Close();\n\t}\n}\ncatch (System.Exception e2)\n{\n\tthrow e2;\n}\nfinally\n{\n\tConn.Close();\n}<\/pre>\n
\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"
 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 =; Password =;”); Conn.Open(); try […]<\/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],"tags":[31,112,106,107],"class_list":["post-18","post","type-post","status-publish","format-standard","hentry","category-programming","tag-csharp","tag-mssql","tag-oledb","tag-oracle","odd"],"yoast_head":"\nOLE DB\ub85c oracle\uc774\uac74 MSSQL\uc774\uac74 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uae30 \uc704\ud55c \uae30\ucd08 \ucf54\ub4dc - 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=18\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"OLE DB\ub85c oracle\uc774\uac74 MSSQL\uc774\uac74 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uae30 \uc704\ud55c \uae30\ucd08 \ucf54\ub4dc - anydragon\" \/>\n<meta property=\"og:description\" content=\"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 =; Password =;"); Conn.Open(); try [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/anyons.net\/?p=18\" \/>\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=\"2009-10-09T10:17:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-12T05:49:28+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\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=18#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=18\"},\"author\":{\"name\":\"anydragon\",\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"headline\":\"OLE DB\ub85c oracle\uc774\uac74 MSSQL\uc774\uac74 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uae30 \uc704\ud55c \uae30\ucd08 \ucf54\ub4dc\",\"datePublished\":\"2009-10-09T10:17:51+00:00\",\"dateModified\":\"2022-07-12T05:49:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=18\"},\"wordCount\":4,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"keywords\":[\"csharp\",\"MSSQL\",\"oledb\",\"oracle\"],\"articleSection\":[\"Programming\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=18#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=18\",\"url\":\"https:\\\/\\\/anyons.net\\\/?p=18\",\"name\":\"OLE DB\ub85c oracle\uc774\uac74 MSSQL\uc774\uac74 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uae30 \uc704\ud55c \uae30\ucd08 \ucf54\ub4dc - anydragon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#website\"},\"datePublished\":\"2009-10-09T10:17:51+00:00\",\"dateModified\":\"2022-07-12T05:49:28+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=18#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=18\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=18#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/anyons.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OLE DB\ub85c oracle\uc774\uac74 MSSQL\uc774\uac74 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uae30 \uc704\ud55c \uae30\ucd08 \ucf54\ub4dc\"}]},{\"@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":"OLE DB\ub85c oracle\uc774\uac74 MSSQL\uc774\uac74 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uae30 \uc704\ud55c \uae30\ucd08 \ucf54\ub4dc - 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=18","og_locale":"ko_KR","og_type":"article","og_title":"OLE DB\ub85c oracle\uc774\uac74 MSSQL\uc774\uac74 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uae30 \uc704\ud55c \uae30\ucd08 \ucf54\ub4dc - anydragon","og_description":"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 =; Password =;\"); Conn.Open(); try [...]","og_url":"https:\/\/anyons.net\/?p=18","og_site_name":"anydragon","article_publisher":"https:\/\/www.facebook.com\/anydragon","article_author":"https:\/\/www.facebook.com\/anydragon","article_published_time":"2009-10-09T10:17:51+00:00","article_modified_time":"2022-07-12T05:49:28+00:00","author":"anydragon","twitter_card":"summary_large_image","twitter_creator":"@anydragon","twitter_site":"@anydragon","twitter_misc":{"\uae00\uc4f4\uc774":"anydragon","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/anyons.net\/?p=18#article","isPartOf":{"@id":"https:\/\/anyons.net\/?p=18"},"author":{"name":"anydragon","@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"headline":"OLE DB\ub85c oracle\uc774\uac74 MSSQL\uc774\uac74 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uae30 \uc704\ud55c \uae30\ucd08 \ucf54\ub4dc","datePublished":"2009-10-09T10:17:51+00:00","dateModified":"2022-07-12T05:49:28+00:00","mainEntityOfPage":{"@id":"https:\/\/anyons.net\/?p=18"},"wordCount":4,"commentCount":0,"publisher":{"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"keywords":["csharp","MSSQL","oledb","oracle"],"articleSection":["Programming"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/anyons.net\/?p=18#respond"]}]},{"@type":"WebPage","@id":"https:\/\/anyons.net\/?p=18","url":"https:\/\/anyons.net\/?p=18","name":"OLE DB\ub85c oracle\uc774\uac74 MSSQL\uc774\uac74 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uae30 \uc704\ud55c \uae30\ucd08 \ucf54\ub4dc - anydragon","isPartOf":{"@id":"https:\/\/anyons.net\/#website"},"datePublished":"2009-10-09T10:17:51+00:00","dateModified":"2022-07-12T05:49:28+00:00","breadcrumb":{"@id":"https:\/\/anyons.net\/?p=18#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/anyons.net\/?p=18"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/anyons.net\/?p=18#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/anyons.net\/"},{"@type":"ListItem","position":2,"name":"OLE DB\ub85c oracle\uc774\uac74 MSSQL\uc774\uac74 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uae30 \uc704\ud55c \uae30\ucd08 \ucf54\ub4dc"}]},{"@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":710,"url":"https:\/\/anyons.net\/?p=710","url_meta":{"origin":18,"position":0},"title":"storedprocedure call","author":"anydragon","date":"2014\ub144 10\uc6d4 14\uc77c","format":false,"excerpt":"SqlConnection conn = new SqlConnection(conStr); SqlCommand cmd = new SqlCommand(\"sp_getdata\", conn); cmd.Parameters.Add(\"@userIndex\", SqlDbType.Int).Value = MemberNo; cmd.CommandType = CommandType.StoredProcedure; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { Fee = Convert.ToInt32(reader[\"Fee\"].ToString()); } conn.Close();","rel":"","context":""Programming"\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2777,"url":"https:\/\/anyons.net\/?p=2777","url_meta":{"origin":18,"position":1},"title":"vscode \uc815\uaddc\uc2dd\uc73c\ub85c \uc601\uc5b4\uac00 \uc544\ub2cc \ubb38\uc790 \uac80\uc0c9\ud558\uae30","author":"anydragon","date":"2022\ub144 07\uc6d4 28\uc77c","format":false,"excerpt":"Cmd(Ctrl) + F \ub610\ub294 Cmd + Shift + F \ub97c \ub20c\ub7ec\uc11c [^\\x00-\\x7F]+\u00a0\ud0a4\uc6cc\ub4dc\ub85c \uac80\uc0c9","rel":"","context":""Command"\uc5d0\uc11c","block_context":{"text":"Command","link":"https:\/\/anyons.net\/?cat=93"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":228,"url":"https:\/\/anyons.net\/?p=228","url_meta":{"origin":18,"position":2},"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":""Command"\uc5d0\uc11c","block_context":{"text":"Command","link":"https:\/\/anyons.net\/?cat=93"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1784,"url":"https:\/\/anyons.net\/?p=1784","url_meta":{"origin":18,"position":3},"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":""Command"\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":18,"position":4},"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":""Programming"\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1766,"url":"https:\/\/anyons.net\/?p=1766","url_meta":{"origin":18,"position":5},"title":"cmd \ub300\uc2e0 \uc0ac\uc6a9\ud558\ub294 powershell \uc758 prompt\uc5d0\uc11c git branch\ud655\uc778","author":"anydragon","date":"2020\ub144 07\uc6d4 30\uc77c","format":false,"excerpt":"Install-Module posh-git -Scope CurrentUser Install-Module oh-my-posh -Scope CurrentUser if (!(Test-Path -Path $PROFILE )) { New-Item -Type File -Path $PROFILE -Force } notepad.exe $PROFILE admin \uad8c\ud55c\uc73c\ub85c Set-ExecutionPolicy -Scope LocalMachine -ExecutionPolicy RemoteSigned -Force \u00a0","rel":"","context":""Command"\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\/18","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=18"}],"version-history":[{"count":0,"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts\/18\/revisions"}],"wp:attachment":[{"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}