{"id":88,"date":"2020-06-02T20:54:40","date_gmt":"2020-06-02T20:54:40","guid":{"rendered":"http:\/\/bahadirmeric.net\/bahadir\/?p=88"},"modified":"2020-06-02T20:54:40","modified_gmt":"2020-06-02T20:54:40","slug":"coalesce-fonksiyonu","status":"publish","type":"post","link":"http:\/\/bahadirmeric.net\/bahadir\/2020\/06\/02\/coalesce-fonksiyonu\/","title":{"rendered":"COALESCE Fonksiyonu"},"content":{"rendered":"\n<p>MS Sql\u2019 de i\u015fimizi kolayla\u015ft\u0131racak fonksiyonlardan biri. Amac\u0131&nbsp;<strong>NULL<\/strong>&nbsp;olmayan de\u011ferin bas\u0131lmas\u0131n\u0131 sa\u011flamak.<\/p>\n\n\n\n<p>Bunu \u015f\u00f6yle d\u00fc\u015f\u00fcnmek gerekli bir sorgu \u00e7ekiyorsunuz ve sorguda da ki\u015finin telefon bilgisinin dolu bir\u015fekil de gelmesini istiyorsunuz. Bunu \u201c<strong>CASE WHEN<\/strong>\u201d kullanarakta yapma \u015fans\u0131n\u0131z var ama biraz daha fazla kod yazarak tabi. \u0130\u015fte tamda bu a\u015famada imdad\u0131m\u0131za \u201c<strong>COALESCE<\/strong>\u201d fonksiyonu yeti\u015fiyor. Fonksiyonun g\u00f6revi yukar\u0131da da dedi\u011fim gibi bo\u015fluk bulunmayan alan\u0131n verisini getirmek. Bunun \u00fczerinde bir \u00f6rnek yapal\u0131m. A\u015fa\u011f\u0131daki gibi bir tablonun veritaban\u0131m\u0131zda oldu\u011funu d\u00fc\u015f\u00fcnelim.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"339\" height=\"119\" src=\"http:\/\/bahadirmeric.net\/bahadir\/wp-content\/uploads\/2020\/06\/Coalesce_1.jpg\" alt=\"\" class=\"wp-image-90\" srcset=\"http:\/\/bahadirmeric.net\/bahadir\/wp-content\/uploads\/2020\/06\/Coalesce_1.jpg 339w, http:\/\/bahadirmeric.net\/bahadir\/wp-content\/uploads\/2020\/06\/Coalesce_1-300x105.jpg 300w, http:\/\/bahadirmeric.net\/bahadir\/wp-content\/uploads\/2020\/06\/Coalesce_1-150x53.jpg 150w, http:\/\/bahadirmeric.net\/bahadir\/wp-content\/uploads\/2020\/06\/Coalesce_1-250x88.jpg 250w\" sizes=\"auto, (max-width: 339px) 100vw, 339px\" \/><\/figure>\n\n\n\n<p>\u015eimdide kodumuzu ve kod \u00e7al\u0131\u015ft\u0131ktan sonraki \u00e7\u0131kt\u0131m\u0131z\u0131 g\u00f6relim;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT\n   Name,\n   COALESCE(Business_Phone, Cell_Phone, Home_Phone) Contact_Phone\nFROM Contact_Info\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"167\" height=\"108\" src=\"http:\/\/bahadirmeric.net\/bahadir\/wp-content\/uploads\/2020\/06\/Coalesce_2.jpg\" alt=\"\" class=\"wp-image-91\" srcset=\"http:\/\/bahadirmeric.net\/bahadir\/wp-content\/uploads\/2020\/06\/Coalesce_2.jpg 167w, http:\/\/bahadirmeric.net\/bahadir\/wp-content\/uploads\/2020\/06\/Coalesce_2-150x97.jpg 150w\" sizes=\"auto, (max-width: 167px) 100vw, 167px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>MS Sql\u2019 de i\u015fimizi kolayla\u015ft\u0131racak fonksiyonlardan biri. Amac\u0131&nbsp;NULL&nbsp;olmayan de\u011ferin bas\u0131lmas\u0131n\u0131 sa\u011flamak. Bunu \u015f\u00f6yle d\u00fc\u015f\u00fcnmek gerekli bir sorgu \u00e7ekiyorsunuz ve sorguda da ki\u015finin telefon bilgisinin dolu bir\u015fekil de gelmesini istiyorsunuz. Bunu \u201cCASE WHEN\u201d kullanarakta yapma \u015fans\u0131n\u0131z var ama biraz daha fazla kod yazarak tabi. \u0130\u015fte tamda bu a\u015famada imdad\u0131m\u0131za \u201cCOALESCE\u201d fonksiyonu&#8230; <a class=\"continue-reading-link\" href=\"http:\/\/bahadirmeric.net\/bahadir\/2020\/06\/02\/coalesce-fonksiyonu\/\"> Continue reading <span class=\"meta-nav\">&rarr; <\/span><\/a><\/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-88","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\/88","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=88"}],"version-history":[{"count":2,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/88\/revisions"}],"predecessor-version":[{"id":92,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/88\/revisions\/92"}],"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=88"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/categories?post=88"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/tags?post=88"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}