<\/div>\n

Merhaba,<\/p>\n

Veritaban\u0131 \u00fczerinde ‘split’ i\u015flemlerini ger\u00e7ekle\u015ftirebilmemiz i\u00e7in SQL Server 2016 versiyonu ile STRING_SPLIT metodu gelmi\u015f bulunmaktad\u0131r. STRING_SPLIT fonksiyonu; elimizdeki bir metinsel de\u011feri, belirtilen bir ayra\u00e7 niteli\u011finde karakterle par\u00e7alamakta ve neticeyi bizlere tablo olarak d\u00f6nd\u00fcrmektedir.<\/p>\n

Prototip olarak a\u015fa\u011f\u0131daki gibidir;<\/p>\n

\r\nstring_split(string, seperator)\r\n<\/pre>\n“string” parametresi, ayr\u0131\u015ft\u0131rman\u0131n yap\u0131laca\u011f\u0131 metinsel de\u011feri ifade ederken char, varchar, nvarchar ve nchar t\u00fcrlerinde olabilir.
\n“seperator” parametresi ise ay\u0131r\u0131c\u0131 sembol\u00fc ifade etmektedir. char(1), varchar(1), nvarchar(1) ve nchar(1) de\u011ferlerini almaktad\u0131r. Burada dikkat edilmesi gereken nokta “seperator” parametresinin bir karakter olmas\u0131 zorundal\u0131\u011f\u0131d\u0131r.<\/p>\n
A\u015fa\u011f\u0131daki \u00f6rne\u011fi incelerkende g\u00f6rece\u011finiz \u00fczere string_split fonksiyonu geriye tablo d\u00f6nd\u00fcrd\u00fc\u011f\u00fc i\u00e7in “Select * from …” kal\u0131b\u0131yla kullan\u0131labilmektedir.
\n<\/a><\/p>\n
Sonraki yaz\u0131lar\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere…
\n\u0130yi \u00e7al\u0131\u015fmalar…<\/p>\n","protected":false},"excerpt":{"rendered":"
Merhaba, Veritaban\u0131 \u00fczerinde ‘split’ i\u015flemlerini ger\u00e7ekle\u015ftirebilmemiz i\u00e7in SQL Server 2016 versiyonu ile STRING_SPLIT metodu gelmi\u015f bulunmaktad\u0131r. STRING_SPLIT fonksiyonu; elimizdeki bir metinsel de\u011feri, belirtilen bir ayra\u00e7 niteli\u011finde karakterle par\u00e7alamakta ve neticeyi bizlere tablo olarak d\u00f6nd\u00fcrmektedir....<\/p>\n","protected":false},"author":1,"featured_media":3415,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1412,22],"tags":[1413,1930,1929,1927,1928],"class_list":["post-6795","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server-2016","category-veritabani","tag-sql-server-2016","tag-sql-server-2016-string_split","tag-sql-server-2016-string_split-fonksiyonu","tag-string_split","tag-string_split-fonksiyonu"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/6795","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/comments?post=6795"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/6795\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media\/3415"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=6795"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=6795"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=6795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}