{"id":27435,"date":"2023-08-01T07:11:00","date_gmt":"2023-08-01T05:11:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=27435"},"modified":"2023-10-09T19:56:41","modified_gmt":"2023-10-09T17:56:41","slug":"funcoes-json-do-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/","title":{"rendered":"Como utilizar as fun\u00e7\u00f5es JSON do SQL Server?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\" id=\"h-introducao-as-funcoes-de-valor-consulta-e-modificacao-json-do-sql-server\"><strong><em>Introdu\u00e7\u00e3o \u00e0s fun\u00e7\u00f5es de valor, consulta e modifica\u00e7\u00e3o JSON do SQL Server.<\/em><\/strong><\/h4>\n\n\n\n<p>No mundo da gest\u00e3o de dados e TI, incluindo, claro, o SQL Server, o uso de JSON (JavaScript Object Notation) tornou-se cada vez mais popular devido ao seu formato leve de troca de dados. Como resultado, o SQL Server incorporou um conjunto de <strong>fun\u00e7\u00f5es JSON do SQL Server<\/strong> no T-SQL para lidar com dados JSON. Este tutorial ir\u00e1 gui\u00e1-lo sobre como usar essas fun\u00e7\u00f5es, come\u00e7ando pelos conceitos b\u00e1sicos e avan\u00e7ando gradualmente para exemplos mais complexos.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#1-compreendendo-o-formato-de-dados-json-no-sql-server\" >1. Compreendendo o formato de dados JSON no SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#2-a-funcao-json-value-no-sql-server\" >2. A fun\u00e7\u00e3o JSON_VALUE no SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#3-trabalhando-com-json-query-no-ms-sql\" >3. Trabalhando com JSON_QUERY no MS SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#4-explorando-a-funcao-isjson-no-t-sql\" >4. Explorando a fun\u00e7\u00e3o ISJSON no T-SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#5-usando-a-funcao-json-modify-no-sql-server\" >5. Usando a fun\u00e7\u00e3o JSON_MODIFY no SQL Server<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-compreendendo-o-formato-de-dados-json-no-sql-server\"><span class=\"ez-toc-section\" id=\"1-compreendendo-o-formato-de-dados-json-no-sql-server\"><\/span>1. Compreendendo o formato de dados JSON no SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Antes de mergulhar nas <strong>fun\u00e7\u00f5es MS SQL JSON<\/strong>, \u00e9 crucial entender o que s\u00e3o os dados JSON. Os dados JSON s\u00e3o um formato de texto que \u00e9 completamente independente de linguagem, mas usa conven\u00e7\u00f5es familiares aos programadores da fam\u00edlia de linguagens C. No SQL, o JSON <a href=\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-data-types\/\"><strong>\u00e9 armazenado como tipo NVARCHAR<\/strong><\/a>. Veja como criar uma tabela com dados JSON:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"> CREATE TABLE Employees (\n     ID INT IDENTITY(1,1),\n     Info NVARCHAR(4000)\n )\n INSERT INTO Employees (Info)\n VALUES ('{\"Name\": \"John\", \"Age\": 25, \"Department\": \"Sales\"}'),\n        ('{\"Name\": \"Jane\", \"Age\": 30, \"Department\": \"Marketing\"}')\n <\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-a-funcao-json-value-no-sql-server\"><span class=\"ez-toc-section\" id=\"2-a-funcao-json-value-no-sql-server\"><\/span>2. A fun\u00e7\u00e3o JSON_VALUE no SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Sobre as fun\u00e7\u00f5es JSON Transact-SQL, uma das fun\u00e7\u00f5es principais que se destaca \u00e9 a JSON_VALUE. Projetada com um prop\u00f3sito simples, <strong>a fun\u00e7\u00e3o JSON_VALUE serve ao papel espec\u00edfico de extrair valores escalares de uma string JSON abrangente<\/strong>. Valores escalares, neste contexto, referem-se a pontos de dados \u00fanicos e n\u00e3o repetidos na estrutura JSON, como inteiros, booleanos ou strings<\/p>\n\n\n\n<p>A primeira fun\u00e7\u00e3o a explorar nas <strong>fun\u00e7\u00f5es JSON Transact-SQL<\/strong> \u00e9 a JSON_VALUE. Esta fun\u00e7\u00e3o extrai um valor escalar de uma string JSON. Aqui est\u00e1 um exemplo simples com uma consulta que retornar\u00e1 apenas os nomes dos funcion\u00e1rios dos dados JSON.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"> SELECT JSON_VALUE(Info, '$.Name') AS EmployeeName\n FROM Employees\n <\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-trabalhando-com-json-query-no-ms-sql\"><span class=\"ez-toc-section\" id=\"3-trabalhando-com-json-query-no-ms-sql\"><\/span>3. Trabalhando com JSON_QUERY no MS SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>JSON_QUERY \u00e9 outra fun\u00e7\u00e3o no conjunto de <strong>fun\u00e7\u00f5es JSON do SQL Server<\/strong>. Ao contr\u00e1rio de JSON_VALUE, JSON_QUERY extrai um objeto ou uma matriz de uma string JSON. Veja abaixo um exemplo b\u00e1sico de como us\u00e1-lo. Esta consulta retornar\u00e1 todos os dados JSON de cada funcion\u00e1rio.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"> SELECT JSON_QUERY(Info, '$') AS EmployeeInfo\n FROM Employees\n <\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-4-explorando-a-funcao-isjson-no-t-sql\"><span class=\"ez-toc-section\" id=\"4-explorando-a-funcao-isjson-no-t-sql\"><\/span>4. Explorando a fun\u00e7\u00e3o ISJSON no T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Na su\u00edte de fun\u00e7\u00f5es JSON do T-SQL, o ISJSON \u00e9 uma ferramenta pr\u00e1tica. Seu principal papel \u00e9 verificar a validade de uma string como formato JSON adequado. Ao ser apresentado com uma string, <strong>o ISJSON retornar\u00e1 um valor de 1 se a string aderir ao padr\u00e3o JSON e 0 se n\u00e3o<\/strong>.<\/p>\n\n\n\n<p>Para entender melhor sua aplica\u00e7\u00e3o, considere o seguinte cen\u00e1rio: um banco de dados cont\u00e9m uma tabela chamada <strong><em>Employees<\/em><\/strong> e, dentro desta tabela, h\u00e1 uma coluna chamada <strong><em>Info<\/em><\/strong>. Cada entrada na coluna Info deve estar no <a href=\"https:\/\/fr.wikipedia.org\/wiki\/JavaScript_Object_Notation\" target=\"_blank\" rel=\"noreferrer noopener\">formato JSON<\/a>. Se houver a necessidade de validar esses dados, a fun\u00e7\u00e3o ISJSON pode ser empregada.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"> SELECT ISJSON(Info) AS IsJson\n FROM Employees\n <\/pre>\n\n\n\n<p>Um resultado de 1 indicaria que o campo &#8216;Info&#8217; correspondente cont\u00e9m uma string JSON v\u00e1lida. Se o banco de dados for bem mantido e consistente, podemos antecipar ver um 1 para cada registro, significando que todas as entradas &#8216;Info&#8217; s\u00e3o JSON v\u00e1lidas.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-5-usando-a-funcao-json-modify-no-sql-server\"><span class=\"ez-toc-section\" id=\"5-usando-a-funcao-json-modify-no-sql-server\"><\/span>5. Usando a fun\u00e7\u00e3o JSON_MODIFY no SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>A fun\u00e7\u00e3o JSON_MODIFY no conjunto de <strong>fun\u00e7\u00f5es JSON do SQL Server<\/strong> permite modificar um valor em uma string JSON. Esta consulta atualizar\u00e1 a idade de John para 26 nos dados JSON.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"> UPDATE Employees\n SET Info = JSON_MODIFY(Info, '$.Age', 26)\n WHERE JSON_VALUE(Info, '$.Name') = 'John'\n <\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-conclusao-sobre-as-funcoes-json-do-sql-server\">Conclus\u00e3o sobre as fun\u00e7\u00f5es JSON do SQL Server<\/h3>\n\n\n\n<p>Em conclus\u00e3o, o SQL Server fornece um conjunto robusto de <strong>fun\u00e7\u00f5es JSON<\/strong> para trabalhar com dados JSON. Essas fun\u00e7\u00f5es fornecem uma maneira perfeita de integrar o tratamento de dados JSON nas suas opera\u00e7\u00f5es SQL. Seja extraindo valores, modificando dados ou validando strings JSON, essas fun\u00e7\u00f5es facilitam e tornam mais eficiente. Ao dominar essas <strong>fun\u00e7\u00f5es JSON do SQL Server<\/strong>, voc\u00ea ser\u00e1 capaz de lidar com dados JSON com facilidade e efici\u00eancia no seu banco de dados SQL Server.<\/p>\n\n\n\n<p>Claro que o SQL Server, como o <strong><a href=\"https:\/\/expert-only.com\/en\/python\/python-import-csv-data-to-sql-server\/\">Python<\/a><\/strong>, tamb\u00e9m permite aos usu\u00e1rios <a href=\"https:\/\/expert-only.com\/pt-pt\/t-sql\/remover-quebras-de-linha-do-sql-server\/\"><strong>inserir ou remover quebras de linha no texto do usando fun\u00e7\u00f5es nativas T-SQL<\/strong><\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-tutoriais-sql-e-ti wp-block-embed-tutoriais-sql-e-ti\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"nl7CJ3ZE5K\"><a href=\"https:\/\/expert-only.com\/pt-pt\/t-sql\/remover-quebras-de-linha-do-sql-server\/\">Como inserir ou remover quebras de linha no texto do SQL Server?<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Como inserir ou remover quebras de linha no texto do SQL Server?&#8221; &#8212; Tutoriais SQL e TI\" src=\"https:\/\/expert-only.com\/pt-pt\/t-sql\/remover-quebras-de-linha-do-sql-server\/embed\/#?secret=mtbLkB7VHZ#?secret=nl7CJ3ZE5K\" data-secret=\"nl7CJ3ZE5K\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>Para leituras adicionais, voc\u00ea pode querer verificar a documenta\u00e7\u00e3o oficial da Microsoft sobre fun\u00e7\u00f5es JSON. Outro \u00f3timo recurso \u00e9 este tutorial da W3Schools sobre SQL e JSON.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Introdu\u00e7\u00e3o \u00e0s fun\u00e7\u00f5es de valor, consulta e modifica\u00e7\u00e3o JSON do SQL Server. No mundo da gest\u00e3o de dados e TI, incluindo, claro, o SQL Server, o uso de JSON (JavaScript Object Notation) tornou-se cada vez mais popular devido ao <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/\" title=\"Como utilizar as fun\u00e7\u00f5es JSON do SQL Server?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10735,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[456],"tags":[],"class_list":{"0":"post-27435","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como utilizar as fun\u00e7\u00f5es JSON do SQL Server? T-SQL<\/title>\n<meta name=\"description\" content=\"Utilizar o formato padr\u00e3o JSON utilizando fun\u00e7\u00f5es nativas do SQL Server como JSON_VALUE, JSON_QUERY ou ISJSON, com exemplos pr\u00e1ticos.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como utilizar as fun\u00e7\u00f5es JSON do SQL Server?\" \/>\n<meta property=\"og:description\" content=\"Utilizar o formato padr\u00e3o JSON utilizando fun\u00e7\u00f5es nativas do SQL Server como JSON_VALUE, JSON_QUERY ou ISJSON, com exemplos pr\u00e1ticos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriais SQL e TI\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-01T05:11:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-09T17:56:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Como utilizar as fun\u00e7\u00f5es JSON do SQL Server?\",\"datePublished\":\"2023-08-01T05:11:00+00:00\",\"dateModified\":\"2023-10-09T17:56:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/\"},\"wordCount\":709,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/\",\"name\":\"Como utilizar as fun\u00e7\u00f5es JSON do SQL Server? T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg\",\"datePublished\":\"2023-08-01T05:11:00+00:00\",\"dateModified\":\"2023-10-09T17:56:41+00:00\",\"description\":\"Utilizar o formato padr\u00e3o JSON utilizando fun\u00e7\u00f5es nativas do SQL Server como JSON_VALUE, JSON_QUERY ou ISJSON, com exemplos pr\u00e1ticos.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"pt\",\"item\":\"https:\/\/expert-only.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como utilizar as fun\u00e7\u00f5es JSON do SQL Server?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#website\",\"url\":\"https:\/\/expert-only.com\/pt-pt\/\",\"name\":\"Tutoriais SQL e TI\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/pt-pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/pt-pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Como utilizar as fun\u00e7\u00f5es JSON do SQL Server? T-SQL","description":"Utilizar o formato padr\u00e3o JSON utilizando fun\u00e7\u00f5es nativas do SQL Server como JSON_VALUE, JSON_QUERY ou ISJSON, com exemplos pr\u00e1ticos.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/","og_locale":"pt_PT","og_type":"article","og_title":"Como utilizar as fun\u00e7\u00f5es JSON do SQL Server?","og_description":"Utilizar o formato padr\u00e3o JSON utilizando fun\u00e7\u00f5es nativas do SQL Server como JSON_VALUE, JSON_QUERY ou ISJSON, com exemplos pr\u00e1ticos.","og_url":"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/","og_site_name":"Tutoriais SQL e TI","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-08-01T05:11:00+00:00","article_modified_time":"2023-10-09T17:56:41+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Escrito por":"Expert-Only","Tempo estimado de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/pt-pt\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Como utilizar as fun\u00e7\u00f5es JSON do SQL Server?","datePublished":"2023-08-01T05:11:00+00:00","dateModified":"2023-10-09T17:56:41+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/"},"wordCount":709,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/pt-pt\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"pt-PT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/","url":"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/","name":"Como utilizar as fun\u00e7\u00f5es JSON do SQL Server? T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/pt-pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg","datePublished":"2023-08-01T05:11:00+00:00","dateModified":"2023-10-09T17:56:41+00:00","description":"Utilizar o formato padr\u00e3o JSON utilizando fun\u00e7\u00f5es nativas do SQL Server como JSON_VALUE, JSON_QUERY ou ISJSON, com exemplos pr\u00e1ticos.","breadcrumb":{"@id":"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/pt-pt\/t-sql\/funcoes-json-do-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"pt","item":"https:\/\/expert-only.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Como utilizar as fun\u00e7\u00f5es JSON do SQL Server?"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/pt-pt\/#website","url":"https:\/\/expert-only.com\/pt-pt\/","name":"Tutoriais SQL e TI","description":"","publisher":{"@id":"https:\/\/expert-only.com\/pt-pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/pt-pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/pt-pt\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/pt-pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/expert-only.com\/pt-pt\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/pt-pt\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/pt-pt\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/expert-only.com\/pt-pt\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/posts\/27435","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=27435"}],"version-history":[{"count":4,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/posts\/27435\/revisions"}],"predecessor-version":[{"id":27439,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/posts\/27435\/revisions\/27439"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/media\/10735"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=27435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=27435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=27435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}