{"id":6988,"date":"2022-03-02T17:28:10","date_gmt":"2022-03-02T08:28:10","guid":{"rendered":"https:\/\/www.auctionpro.co.kr\/?p=6988"},"modified":"2022-03-02T17:45:01","modified_gmt":"2022-03-02T08:45:01","slug":"mssqlinsert%ec%8b%9c-%ec%9e%90%eb%8f%99%ec%a6%9d%ea%b0%80-key%ea%b0%92","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=6988","title":{"rendered":"[MSSQL]Insert\uc2dc \uc790\ub3d9\uc99d\uac00 Key\uac12"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">Remark : [MSSQL]Insert\uc2e4\ud589\uc2dc \uc790\ub3d9\uc99d\uac00\ub418\ub294 IDENTITY\uac12 \ubc14\ub85c \uac00\uc838\uc624\uae30<\/h4>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:tsql decode:true \">SELECT @@IDENTITY<\/pre><\/div>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\uc800\uc7a5\ud504\ub85c\uc2dc\uc800\uc5d0\uc11c \uc801\uc6a9<\/h4>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:tsql decode:true \" >SET ANSI_NULLS ON\nGO\nSET QUOTED_IDENTIFIER ON\nGO\n-- =============================================\n-- Author:\t\t\ud64d\uae38\ub3d9 \n-- Create date: 2022-03-02\n-- Description:\tCACHE \uc800\uc7a5\n-- =============================================\nCREATE PROCEDURE CACHE_Save\n\t-- Add the parameters for the stored procedure here\n\t@IDX int, -- \ub85c\uadf8 \uc678\ub798\ud0a4 \n    @DICSTRING varchar(50),\n    @ENGLISH varchar(50),\n    @KOREAN varchar(50)\n\nAS\nBEGIN\n\t-- SET NOCOUNT ON added to prevent extra result sets from\n\t-- interfering with SELECT statements.\n\tSET NOCOUNT ON;\n\n\tDeclare @iDICSTRING int\n\n\tSet @iDICSTRING = (Select count(*) FROM CACHE Where IDX =@IDX and DICSTRING =@DICSTRING)\n\n\tIf @iDICSTRING=0 -- Save\n\tBegin\n\t  INSERT INTO [dbo].[CACHE]\n           ([IDX]\n           ,[DICSTRING]\n           ,[ENGLISH]\n           ,[KOREAN])\n     VALUES\n           (@IDX\n            ,@DICSTRING\n            ,@ENGLISH\n            ,@KOREAN)\n        \n            SELECT @@IDENTITY AS CACHE_IDX\n\tend\n\telse\n\t   SELECT 0 AS CACHE_IDX\n\nEND\nGO<\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Remark : [MSSQL]Insert\uc2e4\ud589\uc2dc \uc790\ub3d9\uc99d\uac00\ub418\ub294 IDENTITY\uac12 \ubc14\ub85c \uac00\uc838\uc624\uae30 \uc800\uc7a5\ud504\ub85c\uc2dc\uc800\uc5d0\uc11c \uc801\uc6a9<\/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-6988","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\/6988","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=6988"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/6988\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}