{"id":27429,"date":"2023-08-01T07:11:00","date_gmt":"2023-08-01T05:11:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=27429"},"modified":"2023-10-09T19:39:38","modified_gmt":"2023-10-09T17:39:38","slug":"utilizar-funciones-json-de-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/","title":{"rendered":"\u00bfC\u00f3mo utilizar las funciones JSON de SQL Server?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\" id=\"h-introduccion-a-las-funciones-de-valor-consulta-y-modificacion-del-formato-json-con-sql-server\"><strong><em>Introducci\u00f3n a las funciones de valor, consulta y modificaci\u00f3n del formato JSON con SQL Server.<\/em><\/strong><\/h4>\n\n\n\n<p>En el mundo de la gesti\u00f3n de datos y la inform\u00e1tica, incluyendo por supuesto SQL Server, el uso de JSON (JavaScript Object Notation) se ha vuelto cada vez m\u00e1s popular debido a su formato ligero de intercambio de datos. Como resultado, SQL Server ha incorporado un conjunto de <strong>funciones JSON de SQL Server<\/strong> en T-SQL para manejar datos JSON. Este tutorial te guiar\u00e1 sobre c\u00f3mo utilizar estas funciones, comenzando desde lo b\u00e1sico y avanzando gradualmente hacia ejemplos m\u00e1s complejos.<\/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\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#1-comprendiendo-el-formato-de-datos-json-en-sql-server\" >1. Comprendiendo el formato de datos JSON en 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\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#2-la-funcion-json-value-en-sql-server\" >2. La funci\u00f3n JSON_VALUE en 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\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#3-trabajando-con-json-query-en-ms-sql\" >3. Trabajando con JSON_QUERY en 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\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#4-explorando-la-funcion-isjson-en-t-sql\" >4. Explorando la funci\u00f3n ISJSON en 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\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#5-utilizando-la-funcion-json-modify-en-sql-server\" >5. Utilizando la funci\u00f3n JSON_MODIFY en SQL Server<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-comprendiendo-el-formato-de-datos-json-en-sql-server\"><span class=\"ez-toc-section\" id=\"1-comprendiendo-el-formato-de-datos-json-en-sql-server\"><\/span>1. Comprendiendo el formato de datos JSON en SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Antes de adentrarse en las <strong>funciones JSON de MS SQL<\/strong>, es crucial entender qu\u00e9 es la informaci\u00f3n JSON. Los datos JSON son un formato de texto que es completamente independiente del lenguaje pero utiliza convenciones que son familiares para los programadores de la familia de lenguajes C. En SQL, JSON se almacena como tipo NVARCHAR. As\u00ed es c\u00f3mo crear <a href=\"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/\"><strong>una tabla SQL Server<\/strong>,<\/a> pero con datos 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-la-funcion-json-value-en-sql-server\"><span class=\"ez-toc-section\" id=\"2-la-funcion-json-value-en-sql-server\"><\/span>2. La funci\u00f3n JSON_VALUE en SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En cuanto a las funciones JSON de Transact-SQL, una de las funciones principales que destaca es JSON_VALUE. Dise\u00f1ada con un prop\u00f3sito simple, <strong>la funci\u00f3n JSON_VALUE sirve para el papel espec\u00edfico de extraer valores escalares de una cadena JSON completa<\/strong>. Los valores escalares, en este contexto, se refieren a puntos de datos \u00fanicos y no repetidos dentro de la estructura JSON, como enteros, booleanos o cadenas.<\/p>\n\n\n\n<p>La primera funci\u00f3n a explorar en las <strong>funciones JSON de Transact-SQL<\/strong> es JSON_VALUE. Esta funci\u00f3n extrae un valor escalar de una cadena JSON. Aqu\u00ed hay un ejemplo simple con una consulta que simplemente devolver\u00e1 los nombres de los empleados de los datos 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-trabajando-con-json-query-en-ms-sql\"><span class=\"ez-toc-section\" id=\"3-trabajando-con-json-query-en-ms-sql\"><\/span>3. Trabajando con JSON_QUERY en MS SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>JSON_QUERY es otra funci\u00f3n en el conjunto de <strong>funciones JSON de SQL Server<\/strong>. A diferencia de JSON_VALUE, JSON_QUERY extrae un objeto o un array de una cadena JSON. A continuaci\u00f3n se muestra un ejemplo b\u00e1sico de c\u00f3mo utilizarlo. Esta consulta devolver\u00e1 todos los datos JSON de cada empleado.<\/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-la-funcion-isjson-en-t-sql\"><span class=\"ez-toc-section\" id=\"4-explorando-la-funcion-isjson-en-t-sql\"><\/span>4. Explorando la funci\u00f3n ISJSON en T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En el conjunto de funciones JSON de T-SQL, ISJSON se presenta como una herramienta pr\u00e1ctica. Su funci\u00f3n principal es determinar si una cadena es un formato JSON v\u00e1lido. Cuando se presenta con una cadena, <strong>ISJSON devolver\u00e1 un valor de 1 si la cadena cumple con el est\u00e1ndar JSON y un 0 si no lo hace<\/strong>.<\/p>\n\n\n\n<p>Para entender mejor su aplicaci\u00f3n, considere el siguiente escenario: Una base de datos contiene una tabla llamada <strong><em>Employees<\/em><\/strong>, y dentro de esta tabla, hay una columna llamada <strong><em>Info<\/em><\/strong>. Se espera que cada entrada en la columna Info est\u00e9 en <a href=\"https:\/\/fr.wikipedia.org\/wiki\/JavaScript_Object_Notation\" target=\"_blank\" rel=\"noreferrer noopener\">formato JSON<\/a>. Si es necesario validar estos datos, se puede emplear la funci\u00f3n ISJSON.<\/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>Un resultado de 1 indicar\u00eda que el campo &#8216;Info&#8217; correspondiente contiene una cadena JSON v\u00e1lida. Si la base de datos est\u00e1 bien mantenida y es consistente, podemos esperar ver un 1 para cada registro, lo que indica que todas las entradas de &#8216;Info&#8217; son JSON v\u00e1lidos.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-5-utilizando-la-funcion-json-modify-en-sql-server\"><span class=\"ez-toc-section\" id=\"5-utilizando-la-funcion-json-modify-en-sql-server\"><\/span>5. Utilizando la funci\u00f3n JSON_MODIFY en SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La funci\u00f3n JSON_MODIFY en <strong>funciones JSON de SQL Server<\/strong> permite modificar un valor en una cadena JSON. Esta consulta actualizar\u00e1 la edad de John a 26 en los datos 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-conclusion-acerca-de-las-funciones-json-de-sql-server\">Conclusi\u00f3n acerca de las funciones JSON de SQL Server<\/h3>\n\n\n\n<p>En conclusi\u00f3n, SQL Server proporciona un s\u00f3lido conjunto de <strong>funciones JSON<\/strong> para trabajar con datos JSON. Estas funciones proporcionan una forma sencilla de integrar el manejo de datos JSON en tus operaciones SQL. Ya sea que est\u00e9s extrayendo valores, modificando datos o validando cadenas JSON, estas funciones facilitan y hacen m\u00e1s eficiente el proceso. Al dominar estas <strong>funciones JSON de SQL Server<\/strong>, podr\u00e1s manejar datos JSON con facilidad y eficiencia en tu base de datos SQL Server.<\/p>\n\n\n\n<p>Por supuesto, SQL Server, como <strong><a href=\"https:\/\/expert-only.com\/en\/python\/python-import-csv-data-to-sql-server\/\">Python<\/a><\/strong>, tambi\u00e9n permite a los usuarios <a href=\"https:\/\/expert-only.com\/es\/t-sql\/diferencia-entre-dos-fechas-sql-server\/\"><strong>gestionar los fechas utilizando funciones nativas de T-SQL<\/strong><\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-tutoriales-de-sql-y-ti wp-block-embed-tutoriales-de-sql-y-ti\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"fJqaxLBJ5f\"><a href=\"https:\/\/expert-only.com\/es\/t-sql\/diferencia-entre-dos-fechas-sql-server\/\">\u00bfC\u00f3mo calcular la diferencia entre dos fechas SQL Server en horas minutos y segundos?<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00bfC\u00f3mo calcular la diferencia entre dos fechas SQL Server en horas minutos y segundos?\u00bb \u2014 Tutoriales de SQL y TI\" src=\"https:\/\/expert-only.com\/es\/t-sql\/diferencia-entre-dos-fechas-sql-server\/embed\/#?secret=AxRBIV2PVc#?secret=fJqaxLBJ5f\" data-secret=\"fJqaxLBJ5f\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>Para obtener m\u00e1s informaci\u00f3n, puedes consultar la documentaci\u00f3n oficial de Microsoft sobre funciones JSON. Otro gran recurso es este <a href=\"https:\/\/www.w3schools.com\/sql\/sql_json.asp\">tutorial de W3Schools<\/a> sobre SQL y JSON.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Introducci\u00f3n a las funciones de valor, consulta y modificaci\u00f3n del formato JSON con SQL Server. En el mundo de la gesti\u00f3n de datos y la inform\u00e1tica, incluyendo por supuesto SQL Server, el uso de JSON (JavaScript Object Notation) se <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/\" title=\"\u00bfC\u00f3mo utilizar las funciones JSON de SQL Server?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10736,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[455],"tags":[],"class_list":{"0":"post-27429","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>\u00bfC\u00f3mo utilizar las funciones JSON de SQL Server? T-SQL<\/title>\n<meta name=\"description\" content=\"Utilizar el formato est\u00e1ndar JSON con las funciones nativas de SQL Server como JSON_VALUE, JSON_QUERY o ISJSON, con ejemplos pr\u00e1cticos.\" \/>\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\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfC\u00f3mo utilizar las funciones JSON de SQL Server?\" \/>\n<meta property=\"og:description\" content=\"Utilizar el formato est\u00e1ndar JSON con las funciones nativas de SQL Server como JSON_VALUE, JSON_QUERY o ISJSON, con ejemplos pr\u00e1cticos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriales de SQL y 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:39:38+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=\"Tiempo de lectura\" \/>\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\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"\u00bfC\u00f3mo utilizar las funciones JSON de SQL Server?\",\"datePublished\":\"2023-08-01T05:11:00+00:00\",\"dateModified\":\"2023-10-09T17:39:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/\"},\"wordCount\":730,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/es\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/\",\"name\":\"\u00bfC\u00f3mo utilizar las funciones JSON de SQL Server? T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-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:39:38+00:00\",\"description\":\"Utilizar el formato est\u00e1ndar JSON con las funciones nativas de SQL Server como JSON_VALUE, JSON_QUERY o ISJSON, con ejemplos pr\u00e1cticos.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-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\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"es\",\"item\":\"https:\/\/expert-only.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfC\u00f3mo utilizar las funciones JSON de SQL Server?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/es\/#website\",\"url\":\"https:\/\/expert-only.com\/es\/\",\"name\":\"Tutoriales de SQL y TI\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/es\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/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\/es\/#\/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\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/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":"\u00bfC\u00f3mo utilizar las funciones JSON de SQL Server? T-SQL","description":"Utilizar el formato est\u00e1ndar JSON con las funciones nativas de SQL Server como JSON_VALUE, JSON_QUERY o ISJSON, con ejemplos pr\u00e1cticos.","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\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfC\u00f3mo utilizar las funciones JSON de SQL Server?","og_description":"Utilizar el formato est\u00e1ndar JSON con las funciones nativas de SQL Server como JSON_VALUE, JSON_QUERY o ISJSON, con ejemplos pr\u00e1cticos.","og_url":"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/","og_site_name":"Tutoriales de SQL y TI","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-08-01T05:11:00+00:00","article_modified_time":"2023-10-09T17:39:38+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","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"\u00bfC\u00f3mo utilizar las funciones JSON de SQL Server?","datePublished":"2023-08-01T05:11:00+00:00","dateModified":"2023-10-09T17:39:38+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/"},"wordCount":730,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/es\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/","url":"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/","name":"\u00bfC\u00f3mo utilizar las funciones JSON de SQL Server? T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-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:39:38+00:00","description":"Utilizar el formato est\u00e1ndar JSON con las funciones nativas de SQL Server como JSON_VALUE, JSON_QUERY o ISJSON, con ejemplos pr\u00e1cticos.","breadcrumb":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/t-sql\/utilizar-funciones-json-de-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\/es\/t-sql\/utilizar-funciones-json-de-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"es","item":"https:\/\/expert-only.com\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfC\u00f3mo utilizar las funciones JSON de SQL Server?"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/es\/#website","url":"https:\/\/expert-only.com\/es\/","name":"Tutoriales de SQL y TI","description":"","publisher":{"@id":"https:\/\/expert-only.com\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/es\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/#\/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\/es\/#\/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\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/#\/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\/es\/wp-json\/wp\/v2\/posts\/27429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/comments?post=27429"}],"version-history":[{"count":5,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/27429\/revisions"}],"predecessor-version":[{"id":27434,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/27429\/revisions\/27434"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media\/10736"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media?parent=27429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/categories?post=27429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/tags?post=27429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}