{"id":378,"date":"2012-08-19T21:33:36","date_gmt":"2012-08-19T12:33:36","guid":{"rendered":"http:\/\/auctionpro.co.kr\/WPress\/?p=378"},"modified":"2024-07-02T10:18:41","modified_gmt":"2024-07-02T01:18:41","slug":"sql-native-client-%eb%a5%bc-vb-%ec%97%90%ec%84%9c-%ec%82%ac%ec%9a%a9","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=378","title":{"rendered":"SQL Native Client \ub97c vb \uc5d0\uc11c \uc0ac\uc6a9 (UPDATE ERROR (smalldatetime))"},"content":{"rendered":"\n<p>2005 server &nbsp;2008 server \uc778 \uacbd\uc6b0<\/p>\n\n\n\n<p>Public Const Connect = &#8220;PROVIDER=MSDASQL;driver=<br>\n{SQL Native Client};server=111.111.111.111;uid=IDXXX;pwd=PASSXXX2;database=DBXXX&#8221;<\/p>\n\n\n\n<p><span style=\"color: #ff0000;\">UPDATE ERROR (smalldatetime)<\/span><br>\n<span style=\"color: #ff0000;\">\uc778\uc11c\ud2b8\ub294 \uc790\ub3d9\uc73c\ub85c &nbsp;\ud574\uc8fc\uc9c0\ub9cc Update\ub294 CAST \ud574\uc8fc\uc6cc\uc57c \ud568.<\/span><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Format(DEP_DATETIME, \"YYYY-MM-DD hh:mm:ss\")<\/pre>\n\n\n\n<p>SQL Native Client\ub97c \uc0ac\uc6a9\ud558\uc5ec Visual Basic (VB)\uc5d0\uc11c <code>smalldatetime<\/code> \ud615\uc2dd\uc758 \ud544\ub4dc\ub97c \uc5c5\ub370\uc774\ud2b8\ud558\ub824\uace0 \ud560 \ub54c \ubc1c\uc0dd\ud558\ub294 \uc624\ub958\ub294 \ub370\uc774\ud130 \ud615\uc2dd \ubcc0\ud658\uacfc \uad00\ub828\uc774 \uc788\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. INSERT \ubb38\uc5d0\uc11c\ub294 \ud615\uc2dd \ubcc0\ud658\uc774 \uc790\ub3d9\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c0\uc9c0\ub9cc, UPDATE \ubb38\uc5d0\uc11c\ub294 \uba85\uc2dc\uc801\uc73c\ub85c \ubcc0\ud658\uc744 \uc218\ud589\ud574\uc57c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub2e4\uc74c\uc740 VB \ucf54\ub4dc\uc5d0\uc11c SQL UPDATE \ubb38\uc744 \uc791\uc131\ud560 \ub54c <code>smalldatetime<\/code> \ud544\ub4dc\ub97c \uc5c5\ub370\uc774\ud2b8\ud558\ub294 \ubc29\ubc95\uc744 \uc124\uba85\ud558\ub294 \uc608\uc81c\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. SQL Server \ud14c\uc774\ube14 \uc608\uc2dc<\/h3>\n\n\n\n<p>\uc608\ub97c \ub4e4\uc5b4, <code>Employees<\/code> \ud14c\uc774\ube14\uc5d0 <code>HireDate<\/code>\ub77c\ub294 <code>smalldatetime<\/code> \ud615\uc2dd\uc758 \ud544\ub4dc\uac00 \uc788\ub2e4\uace0 \uac00\uc815\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:c# decode:true \" >SQL Native Client\ub97c \uc0ac\uc6a9\ud558\uc5ec Visual Basic (VB)\uc5d0\uc11c smalldatetime \ud615\uc2dd\uc758 \ud544\ub4dc\ub97c \uc5c5\ub370\uc774\ud2b8\ud558\ub824\uace0 \ud560 \ub54c \ubc1c\uc0dd\ud558\ub294 \uc624\ub958\ub294 \ub370\uc774\ud130 \ud615\uc2dd \ubcc0\ud658\uacfc \uad00\ub828\uc774 \uc788\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. INSERT \ubb38\uc5d0\uc11c\ub294 \ud615\uc2dd \ubcc0\ud658\uc774 \uc790\ub3d9\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c0\uc9c0\ub9cc, UPDATE \ubb38\uc5d0\uc11c\ub294 \uba85\uc2dc\uc801\uc73c\ub85c \ubcc0\ud658\uc744 \uc218\ud589\ud574\uc57c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n\n\ub2e4\uc74c\uc740 VB \ucf54\ub4dc\uc5d0\uc11c SQL UPDATE \ubb38\uc744 \uc791\uc131\ud560 \ub54c smalldatetime \ud544\ub4dc\ub97c \uc5c5\ub370\uc774\ud2b8\ud558\ub294 \ubc29\ubc95\uc744 \uc124\uba85\ud558\ub294 \uc608\uc81c\uc785\ub2c8\ub2e4.\n\n1. SQL Server \ud14c\uc774\ube14 \uc608\uc2dc\n\uc608\ub97c \ub4e4\uc5b4, Employees \ud14c\uc774\ube14\uc5d0 HireDate\ub77c\ub294 smalldatetime \ud615\uc2dd\uc758 \ud544\ub4dc\uac00 \uc788\ub2e4\uace0 \uac00\uc815\ud569\ub2c8\ub2e4.<\/pre><\/div>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:c# decode:true \" >CREATE TABLE Employees (\n    EmployeeID int PRIMARY KEY,\n    Name nvarchar(50),\n    HireDate smalldatetime\n);\n<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">2. VB \ucf54\ub4dc \uc608\uc2dc<\/h3>\n\n\n\n<p>VB\uc5d0\uc11c SQL Native Client\ub97c \uc0ac\uc6a9\ud558\uc5ec <code>smalldatetime<\/code> \ud544\ub4dc\ub97c \uc5c5\ub370\uc774\ud2b8\ud558\ub824\uba74, \ub0a0\uc9dc \uac12\uc744 \uc801\uc808\ud788 \ubcc0\ud658\ud558\uc5ec SQL \ucffc\ub9ac\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0 \uc124\uc815<\/h4>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \" >Dim conn As New ADODB.Connection\nDim cmd As New ADODB.Command\n\nconn.ConnectionString = \"Provider=SQLNCLI11;Server=your_server;Database=your_database;Uid=your_username;Pwd=your_password;\"\nconn.Open\ncmd.ActiveConnection = conn\n<\/pre><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">UPDATE \ubb38 \uc791\uc131 \ubc0f \uc2e4\ud589<\/h4>\n\n\n\n<p>\ub0a0\uc9dc \uac12\uc744 <code>smalldatetime<\/code> \ud615\uc2dd\uc73c\ub85c \ubcc0\ud658\ud558\uc5ec UPDATE \ubb38\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \" >Dim employeeID As Integer\nDim hireDate As Date\n\nemployeeID = 1\nhireDate = #2024-07-01 09:30:00# ' \uc608\uc2dc \ub0a0\uc9dc \ubc0f \uc2dc\uac04\n\ncmd.CommandText = \"UPDATE Employees SET HireDate = ? WHERE EmployeeID = ?\"\ncmd.Parameters.Append cmd.CreateParameter(\"HireDate\", adDate, adParamInput, , hireDate)\ncmd.Parameters.Append cmd.CreateParameter(\"EmployeeID\", adInteger, adParamInput, , employeeID)\n\ncmd.Execute\n<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\uc8fc\uc758 \uc0ac\ud56d<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\ub0a0\uc9dc \ud615\uc2dd \uc77c\uad00\uc131 \uc720\uc9c0<\/strong>: VB\uc5d0\uc11c <code>Date<\/code> \ud615\uc2dd\uc744 \uc0ac\uc6a9\ud560 \ub54c, SQL \uc11c\ubc84\uc5d0\uc11c \uae30\ub300\ud558\ub294 \ud615\uc2dd\uacfc \uc77c\uce58\ud558\ub3c4\ub85d \ud574\uc57c \ud569\ub2c8\ub2e4. \ud544\uc694\ud560 \uacbd\uc6b0, VB\uc5d0\uc11c <code>Format<\/code> \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub0a0\uc9dc \ud615\uc2dd\uc744 \ubb38\uc790\uc5f4\ub85c \ubcc0\ud658\ud558\uace0, SQL\uc5d0\uc11c <code>CAST<\/code> \ub610\ub294 <code>CONVERT<\/code> \ud568\uc218\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>SQL Injection \ubc29\uc9c0<\/strong>: \uc704 \uc608\uc81c\uc5d0\uc11c\ub294 \ub9e4\uac1c\ubcc0\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec SQL Injection \uacf5\uaca9\uc744 \ubc29\uc9c0\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc9c1\uc811 \ubb38\uc790\uc5f4\uc744 \uc5f0\uacb0\ud558\uc5ec \ucffc\ub9ac\ub97c \uc791\uc131\ud558\ub294 \uac83\uc740 \ud53c\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\uc5d0\ub7ec \ucc98\ub9ac<\/strong>: \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc791\uc5c5 \uc2dc \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \uc624\ub958\ub97c \ucc98\ub9ac\ud558\ub294 \ucf54\ub4dc\ub97c \ucd94\uac00\ud558\uc5ec \uc548\uc815\uc131\uc744 \ub192\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \" >On Error GoTo ErrorHandler\n\n' (\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc791\uc5c5 \ucf54\ub4dc)\n\nErrorHandler:\nIf Err.Number &lt;&gt; 0 Then\n    MsgBox \"Error: \" &amp; Err.Description\nEnd If\n<\/pre><\/div>\n\n\n\n<p>\uc774 \uc608\uc81c\ub97c \uae30\ubc18\uc73c\ub85c \uc2e4\uc81c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc5f0\uacb0\ud558\uc5ec \uc0ac\uc6a9\ud558\ub294 \ucf54\ub4dc\ub97c \uc791\uc131\ud558\uba74 <code>smalldatetime<\/code> \ud544\ub4dc\ub97c \uc5c5\ub370\uc774\ud2b8\ud560 \ub54c \ubc1c\uc0dd\ud558\ub294 \ubb38\uc81c\ub97c \ud574\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>2005 server &nbsp;2008 server \uc778 \uacbd\uc6b0 Public Const Connect = &#8220;PROVIDER=MSDASQL;driver= {SQL Native Client};server=111.111.111.111;uid=IDXXX;pwd=PASSXXX2;database=DBXXX&#8221; UPDATE ERROR (smalldatetime) \uc778\uc11c\ud2b8\ub294 \uc790\ub3d9\uc73c\ub85c &nbsp;\ud574\uc8fc\uc9c0\ub9cc Update\ub294 CAST \ud574\uc8fc\uc6cc\uc57c \ud568. Format(DEP_DATETIME, <a class=\"mh-excerpt-more\" href=\"https:\/\/www.auctionpro.co.kr\/?p=378\" title=\"SQL Native Client \ub97c vb \uc5d0\uc11c \uc0ac\uc6a9 (UPDATE ERROR (smalldatetime))\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[14],"tags":[],"class_list":["post-378","post","type-post","status-publish","format-standard","hentry","category-visualbasic6-0-vb"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Native Client \ub97c vb \uc5d0\uc11c \uc0ac\uc6a9 (UPDATE ERROR (smalldatetime)) - AuctionPro<\/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:\/\/www.auctionpro.co.kr\/?p=378\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Native Client \ub97c vb \uc5d0\uc11c \uc0ac\uc6a9 (UPDATE ERROR (smalldatetime)) - AuctionPro\" \/>\n<meta property=\"og:description\" content=\"2005 server &nbsp;2008 server \uc778 \uacbd\uc6b0 Public Const Connect = &#8220;PROVIDER=MSDASQL;driver= {SQL Native Client};server=111.111.111.111;uid=IDXXX;pwd=PASSXXX2;database=DBXXX&#8221; UPDATE ERROR (smalldatetime) \uc778\uc11c\ud2b8\ub294 \uc790\ub3d9\uc73c\ub85c &nbsp;\ud574\uc8fc\uc9c0\ub9cc Update\ub294 CAST \ud574\uc8fc\uc6cc\uc57c \ud568. Format(DEP_DATETIME, [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.auctionpro.co.kr\/?p=378\" \/>\n<meta property=\"og:site_name\" content=\"AuctionPro\" \/>\n<meta property=\"article:published_time\" content=\"2012-08-19T12:33:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-02T01:18:41+00:00\" \/>\n<meta name=\"author\" content=\"golgol\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"golgol\" \/>\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:\\\/\\\/www.auctionpro.co.kr\\\/?p=378#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=378\"},\"author\":{\"name\":\"golgol\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#\\\/schema\\\/person\\\/d3dbae599b06cd55f5b14a3e2116f7a2\"},\"headline\":\"SQL Native Client \ub97c vb \uc5d0\uc11c \uc0ac\uc6a9 (UPDATE ERROR (smalldatetime))\",\"datePublished\":\"2012-08-19T12:33:36+00:00\",\"dateModified\":\"2024-07-02T01:18:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=378\"},\"wordCount\":61,\"commentCount\":0,\"articleSection\":[\"[Dev]VB6.0\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=378#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=378\",\"url\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=378\",\"name\":\"SQL Native Client \ub97c vb \uc5d0\uc11c \uc0ac\uc6a9 (UPDATE ERROR (smalldatetime)) - AuctionPro\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#website\"},\"datePublished\":\"2012-08-19T12:33:36+00:00\",\"dateModified\":\"2024-07-02T01:18:41+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#\\\/schema\\\/person\\\/d3dbae599b06cd55f5b14a3e2116f7a2\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=378#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=378\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=378#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\ud648\",\"item\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Native Client \ub97c vb \uc5d0\uc11c \uc0ac\uc6a9 (UPDATE ERROR (smalldatetime))\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#website\",\"url\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/\",\"name\":\"AuctionPro\",\"description\":\"\uc625\uc158\ud504\ub85c\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#\\\/schema\\\/person\\\/d3dbae599b06cd55f5b14a3e2116f7a2\",\"name\":\"golgol\",\"url\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?author=6\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Native Client \ub97c vb \uc5d0\uc11c \uc0ac\uc6a9 (UPDATE ERROR (smalldatetime)) - AuctionPro","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:\/\/www.auctionpro.co.kr\/?p=378","og_locale":"ko_KR","og_type":"article","og_title":"SQL Native Client \ub97c vb \uc5d0\uc11c \uc0ac\uc6a9 (UPDATE ERROR (smalldatetime)) - AuctionPro","og_description":"2005 server &nbsp;2008 server \uc778 \uacbd\uc6b0 Public Const Connect = &#8220;PROVIDER=MSDASQL;driver= {SQL Native Client};server=111.111.111.111;uid=IDXXX;pwd=PASSXXX2;database=DBXXX&#8221; UPDATE ERROR (smalldatetime) \uc778\uc11c\ud2b8\ub294 \uc790\ub3d9\uc73c\ub85c &nbsp;\ud574\uc8fc\uc9c0\ub9cc Update\ub294 CAST \ud574\uc8fc\uc6cc\uc57c \ud568. Format(DEP_DATETIME, [...]","og_url":"https:\/\/www.auctionpro.co.kr\/?p=378","og_site_name":"AuctionPro","article_published_time":"2012-08-19T12:33:36+00:00","article_modified_time":"2024-07-02T01:18:41+00:00","author":"golgol","twitter_card":"summary_large_image","twitter_misc":{"\uae00\uc4f4\uc774":"golgol","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.auctionpro.co.kr\/?p=378#article","isPartOf":{"@id":"https:\/\/www.auctionpro.co.kr\/?p=378"},"author":{"name":"golgol","@id":"https:\/\/www.auctionpro.co.kr\/#\/schema\/person\/d3dbae599b06cd55f5b14a3e2116f7a2"},"headline":"SQL Native Client \ub97c vb \uc5d0\uc11c \uc0ac\uc6a9 (UPDATE ERROR (smalldatetime))","datePublished":"2012-08-19T12:33:36+00:00","dateModified":"2024-07-02T01:18:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.auctionpro.co.kr\/?p=378"},"wordCount":61,"commentCount":0,"articleSection":["[Dev]VB6.0"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.auctionpro.co.kr\/?p=378#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.auctionpro.co.kr\/?p=378","url":"https:\/\/www.auctionpro.co.kr\/?p=378","name":"SQL Native Client \ub97c vb \uc5d0\uc11c \uc0ac\uc6a9 (UPDATE ERROR (smalldatetime)) - AuctionPro","isPartOf":{"@id":"https:\/\/www.auctionpro.co.kr\/#website"},"datePublished":"2012-08-19T12:33:36+00:00","dateModified":"2024-07-02T01:18:41+00:00","author":{"@id":"https:\/\/www.auctionpro.co.kr\/#\/schema\/person\/d3dbae599b06cd55f5b14a3e2116f7a2"},"breadcrumb":{"@id":"https:\/\/www.auctionpro.co.kr\/?p=378#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.auctionpro.co.kr\/?p=378"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.auctionpro.co.kr\/?p=378#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\ud648","item":"https:\/\/www.auctionpro.co.kr\/"},{"@type":"ListItem","position":2,"name":"SQL Native Client \ub97c vb \uc5d0\uc11c \uc0ac\uc6a9 (UPDATE ERROR (smalldatetime))"}]},{"@type":"WebSite","@id":"https:\/\/www.auctionpro.co.kr\/#website","url":"https:\/\/www.auctionpro.co.kr\/","name":"AuctionPro","description":"\uc625\uc158\ud504\ub85c","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.auctionpro.co.kr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Person","@id":"https:\/\/www.auctionpro.co.kr\/#\/schema\/person\/d3dbae599b06cd55f5b14a3e2116f7a2","name":"golgol","url":"https:\/\/www.auctionpro.co.kr\/?author=6"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/378","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=378"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/378\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=378"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}