{"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 class=\"wp-block-paragraph\">2005 server &nbsp;2008 server \uc778 \uacbd\uc6b0<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\"><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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\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,"_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"],"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}]}}