{"id":2176,"date":"2015-06-05T14:40:33","date_gmt":"2015-06-05T05:40:33","guid":{"rendered":"http:\/\/www23.atpages.jp\/~inoni\/?p=2176"},"modified":"2017-10-20T17:34:07","modified_gmt":"2017-10-20T08:34:07","slug":"sqlserver%e8%a6%9a%e6%9b%b8-%e3%82%ab%e3%83%b3%e3%83%9e%e5%8c%ba%e5%88%87%e3%82%8a%e6%96%87%e5%ad%97%e5%88%97%e2%86%92%e8%a1%8c%e3%83%87%e3%83%bc%e3%82%bf","status":"publish","type":"post","link":"http:\/\/anada.cloudfree.jp\/?p=2176","title":{"rendered":"SQLServer\u899a\u66f8 \u30ab\u30f3\u30de\u533a\u5207\u308a\u6587\u5b57\u5217\u2192\u884c\u30c7\u30fc\u30bf"},"content":{"rendered":"<p>\u30ab\u30f3\u30de\u533a\u5207\u308a\u306e\u30c7\u30fc\u30bf\u3092\u7e26\u306b\u4e26\u3079\u308b\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u4f5c\u3063\u3066\u307f\u305f\u3002<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n\nCREATE PROCEDURE csvToRows\n    @csv VARCHAR(MAX)\nAS\nBEGIN\n\n    DECLARE @exit_flg       TINYINT       = 0\n    DECLARE @i              INT           = 1\n    DECLARE @imax           INT\n    DECLARE @buf            VARCHAR(MAX)\n        \n    BEGIN TRY\n        -- \u306f\u3058\u3081\u306bNULL\u3084\u7a7a\u767d\u3092\u56de\u907f\n        IF RTRIM(LTRIM(ISNULL(@csv,'')))='' \n        BEGIN\n            RAISERROR (N'NULL\u306f\u30c0\u30e1\uff01', 18, 1)\n        END\n\n        CREATE TABLE #w_temp (\n            buf            VARCHAR(MAX)\n        )\n        \n        SET @buf = @csv\n        WHILE @exit_flg = 0\n        BEGIN\n            SET @buf = SUBSTRING(@buf, @i  , LEN(@buf))\n            SET @imax = CHARINDEX(',', @buf)\n            IF @imax = 0\n            BEGIN\n                INSERT INTO #w_temp\n                SELECT SUBSTRING(@buf, 1, LEN(@buf)) \n                SET @exit_flg = 1\n            END\n            ELSE\n            BEGIN\n                INSERT INTO #w_temp\n                SELECT SUBSTRING(@buf, 1, @imax - 1) \n                SET @i = @imax + 1\n            END\n        END\n        SELECT 'OK' AS result, NULL AS err_msg, buf FROM #w_temp\n\n    END TRY\n    BEGIN CATCH\n        \n        SELECT 'NG' AS result, ERROR_MESSAGE() AS err_msg\n        \n    END CATCH\nEND\n\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u30ab\u30f3\u30de\u533a\u5207\u308a\u306e\u30c7\u30fc\u30bf\u3092\u7e26\u306b\u4e26\u3079\u308b\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u4f5c\u3063\u3066\u307f\u305f\u3002 CREATE PROCEDURE csvToRows @csv VARCHAR(MAX) AS BEGIN DECLARE @exit_flg TINYINT  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[184,180],"class_list":["post-2176","post","type-post","status-publish","format-standard","hentry","category-sql","tag-db","tag-sqlserver"],"_links":{"self":[{"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/posts\/2176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2176"}],"version-history":[{"count":1,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/posts\/2176\/revisions"}],"predecessor-version":[{"id":2719,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/posts\/2176\/revisions\/2719"}],"wp:attachment":[{"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2176"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}