{"id":58,"date":"2020-06-02T20:27:24","date_gmt":"2020-06-02T20:27:24","guid":{"rendered":"http:\/\/bahadirmeric.net\/bahadir\/?p=58"},"modified":"2020-06-02T20:27:24","modified_gmt":"2020-06-02T20:27:24","slug":"sql-split","status":"publish","type":"post","link":"http:\/\/bahadirmeric.net\/bahadir\/2020\/06\/02\/sql-split\/","title":{"rendered":"SQL Split"},"content":{"rendered":"\n<p>Bazen Sql\u2019 de bir de\u011feri k\u0131s\u0131m k\u0131s\u0131m ay\u0131rma gere\u011fi duyar\u0131z ne yazikki sql bu durumu tam olarak kar\u015f\u0131layacak haz\u0131rda bir fonksiyona sahip de\u011fildir. Bu y\u00fczden de oturup kendiniz yazman\u0131z gerekir. bende en \u00e7ok kulland\u0131\u011f\u0131m ve geriye belirtilen s\u0131radaki de\u011feri d\u00f6nd\u00fcren sql fonksiyonunu sizlerle payla\u015f\u0131yorum.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE FUNCTION &#x5B;dbo].&#x5B;fString_Split]\n(\n       -- Add the parameters for the function here\n       @orj_string NVARCHAR(MAX),\n       @count INT,\n       @split_char NVARCHAR(1)\n)\nRETURNS NVARCHAR(MAX)\nAS\nBEGIN\n       -- Declare the return variable here\n       DECLARE @orj NVARCHAR(MAX)\n       -- Add the T-SQL statements to compute the return value here\n \n       DECLARE @dot_count INT\n       DECLARE @cikarilan NVARCHAR(MAX)\n       DECLARE @dongu INT\n       DECLARE @kalan NVARCHAR(MAX)\n       SET @dongu = 1\n       SET @orj = @orj_string\n       SET @cikarilan = @orj_string\n       SET @dot_count = (LEN(@orj_string) - LEN(REPLACE(@orj_string, @split_char, '')))\n \n       BEGIN\n       WHILE (@dongu &lt;= @count)\n       BEGIN\n             BEGIN\n                    IF ((LEN(@cikarilan) - LEN(REPLACE(@cikarilan, @split_char, ''))) &gt; 0)\n                    BEGIN\n                        SET @kalan = @cikarilan\n                        SET @cikarilan = SUBSTRING(@cikarilan, charindex(@split_char, @cikarilan) + 1, LEN(@cikarilan))\n                        SET @kalan = SUBSTRING(@kalan, 0, charindex(@split_char, @kalan))\n                    END\n                    ELSE\n                    BEGIN\n                        IF (@count &lt;= @dot_count + 1)\n                        BEGIN\n                            SET @kalan = @cikarilan\n                        END\n                        ELSE\n                            SET @kalan = ''\n                    END\n             END\n \n             SET @dongu = @dongu + 1\n       END\n       END\n \n       -- Return the result of the function\n       RETURN REPLACE(@kalan, @split_char, '')\n \nEND\n<\/pre><\/div>\n\n\n<p>Kullan\u0131m\u0131da a\u015fa\u011f\u0131daki \u015fekildedir;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect dbo.fString_Split('Deee-ZZZZ-ffff-gggg-wwwww',1,'-')\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Bazen Sql\u2019 de bir de\u011feri k\u0131s\u0131m k\u0131s\u0131m ay\u0131rma gere\u011fi duyar\u0131z ne yazikki sql bu durumu tam olarak kar\u015f\u0131layacak haz\u0131rda bir fonksiyona sahip de\u011fildir. Bu y\u00fczden de oturup kendiniz yazman\u0131z gerekir. bende en \u00e7ok kulland\u0131\u011f\u0131m ve geriye belirtilen s\u0131radaki de\u011feri d\u00f6nd\u00fcren sql fonksiyonunu sizlerle payla\u015f\u0131yorum. Kullan\u0131m\u0131da a\u015fa\u011f\u0131daki \u015fekildedir;<\/p>\n","protected":false},"author":1,"featured_media":16,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[8,2],"class_list":["post-58","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\/58","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=58"}],"version-history":[{"count":2,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/58\/revisions"}],"predecessor-version":[{"id":60,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/58\/revisions\/60"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/media\/16"}],"wp:attachment":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/media?parent=58"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/categories?post=58"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/tags?post=58"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}