{"id":166,"date":"2012-03-12T22:00:24","date_gmt":"2012-03-12T22:00:24","guid":{"rendered":"http:\/\/www.gencayyildiz.com\/blog\/?p=166"},"modified":"2012-05-01T20:33:00","modified_gmt":"2012-05-01T20:33:00","slug":"transact-sqlcoalesce-isnull-nullif","status":"publish","type":"post","link":"https:\/\/www.gencayyildiz.com\/blog\/transact-sqlcoalesce-isnull-nullif\/","title":{"rendered":"Transact Sql(COALESCE &#8211; ISNULL \u2013 NULLIF)"},"content":{"rendered":"<div id=\"fb-root\"><\/div>\n<p>Bu yaz\u0131mda da Transact sql de Coalesce,isnull ve nullif komutlar\u0131ndan bahsedece\u011fim.<br \/>\n<!--more--><strong><span style=\"color: #ff0000;\">COALESCE &#8211; ISNULL \u2013 NULLIF<\/span><\/strong><\/p>\n<p>E\u011fer tablolar\u0131m\u0131zda \u201cNull\u201d de\u011ferler var ise ilerde bunlar ba\u015f\u0131m\u0131z\u0131 a\u011fr\u0131tabilirler.\u00d6zellikle raporlamada s\u0131k\u0131nt\u0131 \u00e7\u0131karabiliyorlar.E\u011fer kay\u0131t i\u00e7inde \u201cNull\u201d varsa onun yerine \u015funu yaz gibisinden bir ifade kullanmam\u0131z m\u00fcmk\u00fcnd\u00fcr.Bu i\u015flem \u00e7e\u015fitli yollarla yap\u0131labilir.<\/p>\n<p><span style=\"color: #ff6600;\">1-\u00a0\u00a0\u00a0\u00a0\u00a0 Case kullanarak,<\/span><\/p>\n<hr \/>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nselect SirketAdi,case when Bolge is null then 'Tan\u0131ms\u0131z' else Bolge end from Musteriler\r\n<\/pre>\n<hr \/>\n<p><span style=\"color: #ff6600;\">2-\u00a0\u00a0\u00a0\u00a0\u00a0 Coalesce kullanarak,<\/span><\/p>\n<hr \/>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nselect SirketAdi,coalesce(Bolge,'Tan\u0131ms\u0131z') from Musteriler\r\n<\/pre>\n<hr \/>\n<p><span style=\"color: #ff6600;\">3-\u00a0\u00a0\u00a0\u00a0\u00a0 Isnull kullanarak,<\/span><\/p>\n<hr \/>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nselect SirketAdi,ISNULL(Bolge,'Tan\u0131ms\u0131z') from Musteriler\r\n<\/pre>\n<hr \/>\n<p><span style=\"color: #ff6600;\">4-\u00a0\u00a0\u00a0\u00a0\u00a0 Nullif kullanarak,<\/span><\/p>\n<p>E\u011fer kolondaki bir kay\u0131t, verdi\u011fim de\u011fere e\u015fit ise, onun yerine NULL yazar.<br \/>\n\u015eimdi a\u015fa\u011f\u0131daki \u00f6rnekleri inceleyiniz,<br \/>\n\u00dcr\u00fcnlerimin HedefStokDuzeyi ortalamas\u0131n\u0131 alal\u0131m,<\/p>\n<hr \/>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nselect AVG(HedefStokDuzeyi) from Urunler\r\n<\/pre>\n<hr \/>\n<p>Peki<br \/>\nHedefStokDuzeyi 0(s\u0131f\u0131r) olmayan \u00fcr\u00fcnlerimin ortalamas\u0131 nedir?<\/p>\n<hr \/>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nselect AVG(nullif(HedefStokDuzeyi,0)) from Urunler\r\n<\/pre>\n<hr \/>\n<p>nullif(HedefStokDuzeyi,0) = HedefStokDuzeyi 0 olanlar\u0131n de\u011ferini Null yap.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Bu yaz\u0131mda da Transact sql de Coalesce,isnull ve nullif komutlar\u0131ndan bahsedece\u011fim.<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[105,106,107,85],"class_list":["post-166","post","type-post","status-publish","format-standard","hentry","category-veritabani","tag-coalesce","tag-isnull","tag-nullif","tag-transact-sql"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/166","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=166"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/166\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}