{"id":9492,"date":"2024-09-25T10:51:27","date_gmt":"2024-09-25T01:51:27","guid":{"rendered":"https:\/\/www.auctionpro.co.kr\/?p=9492"},"modified":"2024-09-25T10:56:46","modified_gmt":"2024-09-25T01:56:46","slug":"sql-server-%ec%a0%80%ec%9e%a5-%ed%94%84%eb%a1%9c%ec%8b%9c%ec%a0%80-fl","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=9492","title":{"rendered":"SQL Server \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800 Sample"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Overview : SQL Server\uc5d0\uc11c \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub97c \uc791\uc131\ud558\uc5ec <code>RETURN<\/code> \uac12\uc744 \ubc18\ud658\ud558\ub294 \ubc29\ubc95<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">QL Server\uc5d0\uc11c \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub97c \uc791\uc131\ud558\uc5ec <code>RETURN<\/code> \uac12\uc744 \ubc18\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ubcf4\uc5ec\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. \uc774 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub294 \uc608\ub97c \ub4e4\uc5b4, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc5c5\ub370\uc774\ud2b8 \uc791\uc5c5\uc744 \uc218\ud589\ud558\uace0 \uc131\uacf5 \ub610\ub294 \uc2e4\ud328\uc5d0 \ub530\ub77c <code>rtn<\/code> \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc544\ub798\ub294 \uac04\ub2e8\ud55c \uc608\uc81c\uc785\ub2c8\ub2e4:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800 \uc0d8\ud50c<\/h3>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:mysql decode:true \">CREATE PROCEDURE dbo.Tasf_TktNo_Update\n    @TktNo NVARCHAR(13),  -- \ud2f0\ucf13 \ubc88\ud638\n    @NewValue NVARCHAR(100)  -- \uc5c5\ub370\uc774\ud2b8\ud560 \uc0c8\ub85c\uc6b4 \uac12\nAS\nBEGIN\n    -- \ud2b8\ub79c\uc7ad\uc158 \uc2dc\uc791\n    BEGIN TRY\n        BEGIN TRANSACTION;\n        \n        -- \ub370\uc774\ud130 \uc5c5\ub370\uc774\ud2b8\n        UPDATE TicketTable\n        SET ColumnName = @NewValue\n        WHERE TicketNo = @TktNo;\n        \n        -- \uc5c5\ub370\uc774\ud2b8 \uc131\uacf5 \uc2dc \uc601\ud5a5 \ubc1b\uc740 \ud589\uc758 \uc218\ub97c \uccb4\ud06c\n        IF @@ROWCOUNT &gt; 0\n        BEGIN\n            -- \uc131\uacf5 \uc2dc 1 \ubc18\ud658\n            COMMIT TRANSACTION;\n            RETURN 1;\n        END\n        ELSE\n        BEGIN\n            -- \uc5c5\ub370\uc774\ud2b8\ud560 \ud589\uc774 \uc5c6\uc73c\uba74 0 \ubc18\ud658\n            ROLLBACK TRANSACTION;\n            RETURN 0;\n        END\n    END TRY\n    BEGIN CATCH\n        -- \uc5d0\ub7ec \ubc1c\uc0dd \uc2dc \ud2b8\ub79c\uc7ad\uc158 \ub864\ubc31\n        ROLLBACK TRANSACTION;\n        -- \uc624\ub958 \ubc1c\uc0dd \uc2dc -1 \ubc18\ud658\n        RETURN -1;\n    END CATCH\nEND\n<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">2. \uc124\uba85<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\ub9e4\uac1c\ubcc0\uc218<\/strong>\n<ul class=\"wp-block-list\">\n<li><code>@TktNo<\/code>: \uc5c5\ub370\uc774\ud2b8\ud560 \ud2f0\ucf13 \ubc88\ud638.<\/li>\n\n\n\n<li><code>@NewValue<\/code>: \uc5c5\ub370\uc774\ud2b8\ud560 \uc0c8\ub85c\uc6b4 \uac12.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\ub85c\uc9c1<\/strong>\n<ul class=\"wp-block-list\">\n<li><code>TicketTable<\/code>\uc774\ub77c\ub294 \ud14c\uc774\ube14\uc5d0\uc11c \uc8fc\uc5b4\uc9c4 <code>TicketNo<\/code>\uc5d0 \ud574\ub2f9\ud558\ub294 \uac12\uc744 \uc5c5\ub370\uc774\ud2b8\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li>\uc5c5\ub370\uc774\ud2b8\ub41c \ud589\uc774 \uc788\uc73c\uba74 <code>@@ROWCOUNT<\/code>\uac00 0\ubcf4\ub2e4 \ud07d\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 <code>1<\/code>\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li>\uc5c5\ub370\uc774\ud2b8\ud560 \ud589\uc774 \uc5c6\uc73c\uba74 <code>0<\/code>\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li>\uc608\uc678\uac00 \ubc1c\uc0dd\ud558\uba74 \ud2b8\ub79c\uc7ad\uc158\uc744 \ub864\ubc31\ud558\uace0 <code>-1<\/code>\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">3. C#\uc5d0\uc11c \ud638\ucd9c \uc608\uc81c<\/h3>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:mysql decode:true \" >using (SqlConnection conn = new SqlConnection(connectionString))\n{\n    SqlCommand cmd = new SqlCommand(\"dbo.Tasf_TktNo_Update\", conn);\n    cmd.CommandType = CommandType.StoredProcedure;\n\n    \/\/ \ud30c\ub77c\ubbf8\ud130 \uc124\uc815\n    cmd.Parameters.AddWithValue(\"@TktNo\", \"1234567890123\");\n    cmd.Parameters.AddWithValue(\"@NewValue\", \"Updated Value\");\n\n    \/\/ \ubc18\ud658\uac12 \ubc1b\uc744 \ud30c\ub77c\ubbf8\ud130 \uc124\uc815\n    SqlParameter returnValue = new SqlParameter();\n    returnValue.Direction = ParameterDirection.ReturnValue;\n    cmd.Parameters.Add(returnValue);\n\n    conn.Open();\n    cmd.ExecuteNonQuery();\n\n    \/\/ \ubc18\ud658\uac12 \ud655\uc778\n    int rtn = (int)returnValue.Value;\n\n    if (rtn == 1)\n    {\n        Console.WriteLine(\"\uc5c5\ub370\uc774\ud2b8 \uc131\uacf5\");\n    }\n    else if (rtn == 0)\n    {\n        Console.WriteLine(\"\uc5c5\ub370\uc774\ud2b8\ud560 \ud589\uc774 \uc5c6\uc74c\");\n    }\n    else if (rtn == -1)\n    {\n        Console.WriteLine(\"\uc5c5\ub370\uc774\ud2b8 \uc911 \uc624\ub958 \ubc1c\uc0dd\");\n    }\n}\n<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">4. \uc124\uba85<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>C# \ucf54\ub4dc<\/strong>\uc5d0\uc11c <code>SqlParameter<\/code>\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\uc758 \ubc18\ud658 \uac12\uc744 \ubc1b\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li>\uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\uac00 \uc2e4\ud589\ub41c \ud6c4 <code>returnValue.Value<\/code>\uc5d0\uc11c \ubc18\ud658\ub41c \uac12\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n<ul class=\"wp-block-list\">\n<li><code>1<\/code>: \uc131\uacf5\uc801\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ub428.<\/li>\n\n\n\n<li><code>0<\/code>: \uc5c5\ub370\uc774\ud2b8\ud560 \ud589\uc774 \uc5c6\uc74c.<\/li>\n\n\n\n<li><code>-1<\/code>: \uc624\ub958\uac00 \ubc1c\uc0dd\ud568.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ubc29\uc2dd\uc73c\ub85c \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\uc5d0\uc11c \uc791\uc5c5\uc758 \uc131\uacf5, \uc2e4\ud328, \ub610\ub294 \ud2b9\uc815 \uc0c1\ud669\uc5d0 \ub530\ub77c \ubc18\ud658 \uac12\uc744 \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Overview : SQL Server\uc5d0\uc11c \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub97c \uc791\uc131\ud558\uc5ec RETURN \uac12\uc744 \ubc18\ud658\ud558\ub294 \ubc29\ubc95 QL Server\uc5d0\uc11c \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub97c \uc791\uc131\ud558\uc5ec RETURN \uac12\uc744 \ubc18\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ubcf4\uc5ec\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. \uc774 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub294 \uc608\ub97c <a class=\"mh-excerpt-more\" href=\"https:\/\/www.auctionpro.co.kr\/?p=9492\" title=\"SQL Server \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800 Sample\">[&#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":[16],"tags":[],"class_list":["post-9492","post","type-post","status-publish","format-standard","hentry","category-mssql-server"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/9492","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=9492"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/9492\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}