{"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<pre class=\"lang:c# decode:true \">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<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p> private OleDbDataReader rd; private OleDbConnection Conn; private string strRet; private OleDbCommand cmd; private StringBuilder sbSQL; private OleDbParameter paramnSeq; try { \/\/ SQLOLEDB MSDAORA Conn = new OleDbConnection(&#8220;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 =;&#8221;); Conn.Open(); try [&#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":[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":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<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<\/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(&quot;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 =;&quot;); 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":"&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":18,"position":1},"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":2777,"url":"https:\/\/anyons.net\/?p=2777","url_meta":{"origin":18,"position":2},"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":"&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":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":"&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":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":"&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":18,"position":5},"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":[]}],"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}]}}