{"id":5372,"date":"2016-11-16T12:21:24","date_gmt":"2016-11-16T12:21:24","guid":{"rendered":"http:\/\/www.gencayyildiz.com\/blog\/?p=5372"},"modified":"2016-11-16T12:25:11","modified_gmt":"2016-11-16T12:25:11","slug":"sql-server-2016-isjson-fonksiyonu","status":"publish","type":"post","link":"https:\/\/www.gencayyildiz.com\/blog\/sql-server-2016-isjson-fonksiyonu\/","title":{"rendered":"SQL Server 2016 &#8211; ISJSON Fonksiyonu"},"content":{"rendered":"<div id=\"fb-root\"><\/div>\n<p>Merhaba,<\/p>\n<p>\u00d6nceki yaz\u0131lar\u0131mda SQL Server 2016 ile gelen bir\u00e7ok yenili\u011fi ele alm\u0131\u015ft\u0131k. Haliyle bunlar aras\u0131nda JSON veri format\u0131na \u00f6zel yenilik ve fonksiyonelliklerden bahsetmi\u015ftik. Bu i\u00e7eri\u011fimizde tekrar JSON \u00fczerinde fonksiyonellik \u00f6zelli\u011fi olarak kazand\u0131r\u0131lm\u0131\u015f bir yenilik olan ISJSON fonksiyonu \u00fczerine konu\u015fuyor olaca\u011f\u0131z.<\/p>\n<p>ISJSON fonksiyonu elimizdeki verinin JSON format\u0131na uygun olup olmad\u0131\u011f\u0131n\u0131 kontrol etmemizi sa\u011flayan bir i\u015flevselli\u011fe sahiptir. E\u011fer veri JSON format\u0131nda ise &#8220;1&#8221; yok e\u011fer de\u011filse &#8220;0&#8221; de\u011ferini d\u00f6nd\u00fcrmektedir.<\/p>\n<p>\u015eimdi a\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fcn\u00fc inceleyiniz.<br \/>\n<a href=\"http:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2016\/11\/SQL-Server-2016-ISJSON-Fonksiyonu.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2016\/11\/SQL-Server-2016-ISJSON-Fonksiyonu.png\" alt=\"SQL Server 2016 - ISJSON Fonksiyonu\" width=\"454\" height=\"166\" class=\"aligncenter size-full wp-image-5374\" srcset=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2016\/11\/SQL-Server-2016-ISJSON-Fonksiyonu.png 454w, https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2016\/11\/SQL-Server-2016-ISJSON-Fonksiyonu-300x110.png 300w\" sizes=\"auto, (max-width: 454px) 100vw, 454px\" \/><\/a><\/p>\n<p>G\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere IsJson fonksiyonunun i\u015flevi a\u015fikard\u0131r&#8230;<\/p>\n<p>Hat\u0131rlarsan\u0131z e\u011fer <a href=\"http:\/\/www.gencayyildiz.com\/blog\/sql-server-2016-openjson-fonksiyonu\/\" target=\"_blank\">SQL Server 2016 \u2013 OpenJson Fonksiyonu<\/a> ba\u015fl\u0131kl\u0131 yaz\u0131m\u0131zda OpenJson fonksiyonu \u00fczerine konu\u015fmu\u015f ve JSON veri yap\u0131s\u0131nda sorgulama ger\u00e7ekle\u015ftirmi\u015ftik. S\u00f6zgelimi OpenJson fonksiyonunu kullanmadan \u00f6nce elimizdeki verinin IsJson fonksiyonu arac\u0131l\u0131\u011f\u0131yla beklenen formatta olup olmad\u0131\u011f\u0131n\u0131 de\u011ferlendirebilir, ard\u0131ndan sonuca g\u00f6re OpenJson fonksyonunu devreye sokabiliriz.<\/p>\n<p><a href=\"http:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2016\/11\/SQL-Server-2016-ISJSON-Fonksiyonu-1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2016\/11\/SQL-Server-2016-ISJSON-Fonksiyonu-1.png\" alt=\"SQL Server 2016 - ISJSON Fonksiyonu\" width=\"310\" height=\"197\" class=\"aligncenter size-full wp-image-5379\" srcset=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2016\/11\/SQL-Server-2016-ISJSON-Fonksiyonu-1.png 310w, https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2016\/11\/SQL-Server-2016-ISJSON-Fonksiyonu-1-300x191.png 300w\" sizes=\"auto, (max-width: 310px) 100vw, 310px\" \/><\/a><\/p>\n<p>G\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere&#8230;<\/p>\n<p>Sonraki yaz\u0131lar\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere&#8230;<br \/>\n\u0130yi \u00e7al\u0131\u015fmalar&#8230;<\/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>Merhaba, \u00d6nceki yaz\u0131lar\u0131mda SQL Server 2016 ile gelen bir\u00e7ok yenili\u011fi ele alm\u0131\u015ft\u0131k. Haliyle bunlar aras\u0131nda JSON veri format\u0131na \u00f6zel yenilik ve fonksiyonelliklerden bahsetmi\u015ftik. Bu i\u00e7eri\u011fimizde tekrar JSON \u00fczerinde fonksiyonellik \u00f6zelli\u011fi olarak kazand\u0131r\u0131lm\u0131\u015f bir yenilik&#46;&#46;&#46;<!-- 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":3415,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1082,1412,22],"tags":[1550,1551,1539,1552],"class_list":["post-5372","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","category-sql-server-2016","category-veritabani","tag-isjson","tag-isjson-fonksiyonu","tag-sql-server-2016-yenilikleri","tag-t-sql-isjson"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/5372","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=5372"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/5372\/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=5372"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=5372"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=5372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}