{"id":61,"date":"2020-06-02T20:29:17","date_gmt":"2020-06-02T20:29:17","guid":{"rendered":"http:\/\/bahadirmeric.net\/bahadir\/?p=61"},"modified":"2020-06-02T20:29:17","modified_gmt":"2020-06-02T20:29:17","slug":"tablo-donduren-sql-split","status":"publish","type":"post","link":"http:\/\/bahadirmeric.net\/bahadir\/2020\/06\/02\/tablo-donduren-sql-split\/","title":{"rendered":"Tablo D\u00f6nd\u00fcren SQL Split"},"content":{"rendered":"\n<p>\u00d6nceki yaz\u0131lar\u0131m\u0131zda SQL Split fonksiyonuna yer vermi\u015ftim fakat bu fonksiyon sadece bir adet de\u011fer d\u00f6nd\u00fcrmeye yar\u0131yor idi. Oysa baz\u0131 durumlarda biz verdi\u011fimiz de\u011ferin tamam\u0131n\u0131n par\u00e7alan\u0131p bize geri d\u00f6nd\u00fcr\u00fclmesini isteyebiliriz i\u015fte b\u00f6yle durumlarda da a\u015fa\u011f\u0131daki fonksiyonu kullanaca\u011f\u0131z.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE FUNCTION &#x5B;dbo].&#x5B;Split](@STRING nvarchar(4000), @Delimiter char(1))\nRETURNS @Results TABLE (Items nvarchar(4000))\nAS\n    BEGIN\n        DECLARE @INDEX INT\n        DECLARE @SLICE nvarchar(4000)\n        SELECT @INDEX = 1\n \n        IF @STRING IS NULL RETURN\n        WHILE @INDEX !=0\n        BEGIN\n            SELECT @INDEX = CHARINDEX(@Delimiter,@STRING)\n \n            IF @INDEX !=0\n                SELECT @SLICE = RTRIM(LTRIM(LEFT(@STRING,@INDEX - 1)))\n            ELSE\n                SELECT @SLICE = RTRIM(LTRIM(@STRING))\n \n            INSERT INTO @Results(Items) VALUES(@SLICE)\n \n            SELECT @STRING = RIGHT(@STRING,LEN(@STRING) - @INDEX)\n \n            IF LEN(@STRING) = 0 BREAK\n        END\n    RETURN\nEND\n<\/pre><\/div>\n\n\n<p>Kodun kullan\u0131\u015f\u0131da a\u015fa\u011f\u0131daki gibidir;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect * from dbo.Split('Deee-zzzz-fff-ttt','-')\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>\u00d6nceki yaz\u0131lar\u0131m\u0131zda SQL Split fonksiyonuna yer vermi\u015ftim fakat bu fonksiyon sadece bir adet de\u011fer d\u00f6nd\u00fcrmeye yar\u0131yor idi. Oysa baz\u0131 durumlarda biz verdi\u011fimiz de\u011ferin tamam\u0131n\u0131n par\u00e7alan\u0131p bize geri d\u00f6nd\u00fcr\u00fclmesini isteyebiliriz i\u015fte b\u00f6yle durumlarda da a\u015fa\u011f\u0131daki fonksiyonu kullanaca\u011f\u0131z. Kodun kullan\u0131\u015f\u0131da a\u015fa\u011f\u0131daki gibidir;<\/p>\n","protected":false},"author":1,"featured_media":10,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[8,2],"class_list":["post-61","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-ms-sql","tag-sql"],"_links":{"self":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/61","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/comments?post=61"}],"version-history":[{"count":1,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/61\/revisions"}],"predecessor-version":[{"id":62,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/61\/revisions\/62"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/media\/10"}],"wp:attachment":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/media?parent=61"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/categories?post=61"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/tags?post=61"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}