{"id":82,"date":"2020-06-02T20:46:05","date_gmt":"2020-06-02T20:46:05","guid":{"rendered":"http:\/\/bahadirmeric.net\/bahadir\/?p=82"},"modified":"2020-06-02T20:46:05","modified_gmt":"2020-06-02T20:46:05","slug":"utilfn_split-fonksiyonu","status":"publish","type":"post","link":"http:\/\/bahadirmeric.net\/bahadir\/2020\/06\/02\/utilfn_split-fonksiyonu\/","title":{"rendered":"UTILfn_Split fonksiyonu"},"content":{"rendered":"\n<p>Merhabalar bu fonksiyonu daha \u00e7ok tek seferde de\u011fer g\u00f6nderdi\u011fim string de\u011ferleri ayr\u0131\u015ft\u0131r\u0131p sql i\u00e7inde kullanmak i\u00e7in kullan\u0131r\u0131m. Sql parametrede de\u011fer ge\u00e7erken aralar\u0131n\u0131standartta (,) ile ay\u0131rman\u0131z gerekli.<\/p>\n\n\n\n<p>Kodu a\u015fa\u011f\u0131da veriyorum;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE function &#x5B;dbo].&#x5B;UTILfn_Split](\n@String nvarchar (4000),\n@Delimiter nvarchar (10)\n)\nreturns @ValueTable table (ID int IDENTITY(1,1) NOT NULL,&#x5B;Value] nvarchar(4000))\nbegin\ndeclare @NextString nvarchar(4000)\ndeclare @Pos int\ndeclare @NextPos int\ndeclare @CommaCheck nvarchar(1)\n \n--Initialize\nset @NextString = ''\nset @CommaCheck = right(@String,1)\n \n--Check for trailing Comma, if not exists, INSERT\n--if (@CommaCheck &lt;&gt; @Delimiter )\nset @String = @String + @Delimiter\n \n--Get position of first Comma\nset @Pos = charindex(@Delimiter,@String)\nset @NextPos = 1\n \n--Loop while there is still a comma in the String of levels\nwhile (@pos &lt;&gt; 0)\nbegin\nset @NextString = substring(@String,1,@Pos - 1)\n \ninsert into @ValueTable ( &#x5B;Value]) Values (@NextString)\n \nset @String = substring(@String,@pos +1,len(@String))\n \nset @NextPos = @Pos\nset @pos = charindex(@Delimiter,@String)\nend\n \nreturn\nend\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Merhabalar bu fonksiyonu daha \u00e7ok tek seferde de\u011fer g\u00f6nderdi\u011fim string de\u011ferleri ayr\u0131\u015ft\u0131r\u0131p sql i\u00e7inde kullanmak i\u00e7in kullan\u0131r\u0131m. Sql parametrede de\u011fer ge\u00e7erken aralar\u0131n\u0131standartta (,) ile ay\u0131rman\u0131z gerekli. Kodu a\u015fa\u011f\u0131da veriyorum;<\/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-82","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\/82","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=82"}],"version-history":[{"count":1,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/82\/revisions"}],"predecessor-version":[{"id":83,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/82\/revisions\/83"}],"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=82"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/categories?post=82"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/tags?post=82"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}