{"id":27425,"date":"2023-08-01T07:11:00","date_gmt":"2023-08-01T05:11:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=27425"},"modified":"2023-10-09T19:57:55","modified_gmt":"2023-10-09T17:57:55","slug":"fonctions-sql-server-json","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/","title":{"rendered":"Fonctions SQL Server JSON : exemples de requ\u00eates"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\" id=\"h-introduction-aux-fonctions-sql-server-natives-json-value-json-query-et-json-modify-pour-gerer-le-format-json\"><strong><em>Introduction aux fonctions SQL Server natives JSON_VALUE, JSON_QUERY et JSON_MODIFY pour g\u00e9rer le format JSON.<\/em><\/strong><\/h4>\n\n\n\n<p>Dans le monde de la gestion des donn\u00e9es et de l&rsquo;informatique, y compris SQL Server, l&rsquo;utilisation de JSON (JavaScript Object Notation) est devenue de plus en plus populaire en raison de son format d&rsquo;\u00e9change de donn\u00e9es l\u00e9ger. En cons\u00e9quence, SQL Server a incorpor\u00e9 un ensemble de <strong>fonctions JSON de SQL Server<\/strong> dans T-SQL pour g\u00e9rer les donn\u00e9es JSON. Ce tutoriel vous guidera sur l&rsquo;utilisation de ces fonctions, en commen\u00e7ant par les bases et en passant progressivement \u00e0 des exemples plus complexes.<\/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\/fr\/t-sql\/fonctions-sql-server-json\/#1-comprendre-le-format-de-donnees-json-dans-sql-server\" >1. Comprendre le format de donn\u00e9es JSON dans 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\/fr\/t-sql\/fonctions-sql-server-json\/#2-la-fonction-json-value-dans-sql-server\" >2. La fonction JSON_VALUE dans 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\/fr\/t-sql\/fonctions-sql-server-json\/#3-travailler-avec-json-query-dans-ms-sql\" >3. Travailler avec JSON_QUERY dans 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\/fr\/t-sql\/fonctions-sql-server-json\/#4-explorer-la-fonction-isjson-dans-t-sql\" >4. Explorer la fonction ISJSON dans 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\/fr\/t-sql\/fonctions-sql-server-json\/#5-utiliser-la-fonction-sql-server-json-modify\" >5. Utiliser la fonction SQL Server JSON_MODIFY<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-comprendre-le-format-de-donnees-json-dans-sql-server\"><span class=\"ez-toc-section\" id=\"1-comprendre-le-format-de-donnees-json-dans-sql-server\"><\/span>1. Comprendre le format de donn\u00e9es JSON dans SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Avant de plonger dans les <strong>fonctions MS SQL JSON<\/strong>, il est crucial de comprendre ce qu&rsquo;est une donn\u00e9e JSON. Les donn\u00e9es JSON sont un format de texte compl\u00e8tement ind\u00e9pendant de la langue, mais utilisent des conventions famili\u00e8res aux programmeurs de la famille des langages C. Dans SQL, JSON <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/les-types-de-donnees-sql-server\/\"><strong>est stock\u00e9 sous le type NVARCHAR<\/strong><\/a>. Voici comment cr\u00e9er une table avec des donn\u00e9es 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\"}')<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-la-fonction-json-value-dans-sql-server\"><span class=\"ez-toc-section\" id=\"2-la-fonction-json-value-dans-sql-server\"><\/span>2. La fonction JSON_VALUE dans SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En ce qui concerne les fonctions JSON de Transact-SQL, l&rsquo;une des fonctions principales qui se d\u00e9marque est JSON_VALUE. Con\u00e7ue avec un objectif simple, <strong>la fonction JSON_VALUE sert le r\u00f4le sp\u00e9cifique d&rsquo;extraire des valeurs scalaires \u00e0 partir d&rsquo;une cha\u00eene JSON compl\u00e8te<\/strong>. Les valeurs scalaires, dans ce contexte, font r\u00e9f\u00e9rence \u00e0 des points de donn\u00e9es uniques et non r\u00e9p\u00e9t\u00e9s dans la structure JSON, tels que les entiers, les bool\u00e9ens ou les cha\u00eenes<\/p>\n\n\n\n<p>La premi\u00e8re fonction \u00e0 explorer dans les <strong>fonctions JSON de Transact-SQL<\/strong> est JSON_VALUE. Cette fonction extrait une valeur scalaire d&rsquo;une cha\u00eene JSON. Voici un exemple simple avec une requ\u00eate qui renverra simplement les noms des employ\u00e9s \u00e0 partir des donn\u00e9es 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-travailler-avec-json-query-dans-ms-sql\"><span class=\"ez-toc-section\" id=\"3-travailler-avec-json-query-dans-ms-sql\"><\/span>3. Travailler avec JSON_QUERY dans MS SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>JSON_QUERY est une autre fonction de l&rsquo;ensemble des <strong>fonctions JSON de SQL Server<\/strong>. Contrairement \u00e0 JSON_VALUE, JSON_QUERY extrait un objet ou un tableau d&rsquo;une cha\u00eene JSON. Voici ci-dessous un exemple basique sur comment l&rsquo;utiliser. Cette requ\u00eate renverra les donn\u00e9es JSON compl\u00e8tes pour chaque employ\u00e9.<\/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-explorer-la-fonction-isjson-dans-t-sql\"><span class=\"ez-toc-section\" id=\"4-explorer-la-fonction-isjson-dans-t-sql\"><\/span>4. Explorer la fonction ISJSON dans T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Dans la suite des fonctions JSON de T-SQL, ISJSON se pr\u00e9sente comme un outil pratique. Son r\u00f4le principal est de v\u00e9rifier la validit\u00e9 d&rsquo;une cha\u00eene en tant que format JSON correct. Lorsqu&rsquo;il est pr\u00e9sent\u00e9 avec une cha\u00eene, <strong>ISJSON renverra une valeur de 1 si la cha\u00eene est conforme \u00e0 la norme JSON et 0 si ce n&rsquo;est pas le cas<\/strong>.<\/p>\n\n\n\n<p>Pour mieux comprendre son application, consid\u00e9rez le sc\u00e9nario suivant: une base de donn\u00e9es contient une table appel\u00e9e <strong><em>Employees<\/em><\/strong> et dans cette table, il y a une colonne appel\u00e9e <strong><em>Info<\/em><\/strong>. Chaque entr\u00e9e dans la colonne Info est cens\u00e9e \u00eatre au format <a href=\"https:\/\/fr.wikipedia.org\/wiki\/JavaScript_Object_Notation\" target=\"_blank\" rel=\"noreferrer noopener\">JSON<\/a>. S&rsquo;il y a un besoin de valider ces donn\u00e9es, la fonction ISJSON peut \u00eatre utilis\u00e9e.<\/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 r\u00e9sultat de 1 indiquerait que le champ &lsquo;Info&rsquo; correspondant contient une cha\u00eene JSON valide. Si la base de donn\u00e9es est bien entretenue et coh\u00e9rente, nous pouvons anticiper de voir un 1 pour chaque enregistrement, signifiant que toutes les entr\u00e9es &lsquo;Info&rsquo; sont du JSON valide.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-5-utiliser-la-fonction-sql-server-json-modify\"><span class=\"ez-toc-section\" id=\"5-utiliser-la-fonction-sql-server-json-modify\"><\/span>5. Utiliser la fonction SQL Server JSON_MODIFY<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La fonction JSON_MODIFY dans les <strong>fonctions JSON de SQL Server<\/strong> permet de modifier une valeur dans une cha\u00eene JSON. Cette requ\u00eate mettra \u00e0 jour l&rsquo;\u00e2ge de John \u00e0 26 dans les donn\u00e9es 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-sur-les-fonctions-json-de-sql-server\">Conclusion sur les fonctions JSON de SQL Server<\/h3>\n\n\n\n<p>En conclusion, SQL Server fournit un ensemble robuste de <strong>fonctions JSON<\/strong> pour travailler avec des donn\u00e9es JSON. Ces fonctions offrent un moyen transparent d&rsquo;int\u00e9grer la gestion des donn\u00e9es JSON dans vos op\u00e9rations SQL. Que vous extrayiez des valeurs, modifiiez des donn\u00e9es ou validiez des cha\u00eenes JSON, ces fonctions facilitent et rendent le processus plus efficace. En ma\u00eetrisant ces <strong>fonctions JSON de SQL Server<\/strong>, vous pourrez g\u00e9rer les donn\u00e9es JSON avec facilit\u00e9 et efficacit\u00e9 dans votre base de donn\u00e9es SQL Server.<\/p>\n\n\n\n<p>Bien s\u00fbr, SQL Server, comme <strong><a href=\"https:\/\/expert-only.com\/fr\/python\/se-connecter-a-sql-server-avec-python\/\">Python<\/a><\/strong>, permet \u00e9galement aux utilisateurs de <a href=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/\"><strong>g\u00e9rer les types de donn\u00e9es XML en utilisant des fonctions T-SQL natives<\/strong><\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"eE01qKRiGZ\"><a href=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/\">Importer un fichier XML dans une table avec SSIS<\/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\u00a0Importer un fichier XML dans une table avec SSIS\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/embed\/#?secret=inIyfEIHVB#?secret=eE01qKRiGZ\" data-secret=\"eE01qKRiGZ\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>Pour aller encore plus loin sur MS SQL et le format JSON, consulter la documentation officielle de Microsoft sur les <a href=\"https:\/\/www.w3schools.com\/js\/js_json.asp\" target=\"_blank\" rel=\"noreferrer noopener\">fonctions JSON<\/a>. Une autre excellente ressource est ce <a href=\"https:\/\/www.w3schools.com\/sql\/sql_json.asp\">tutoriel W3Schools<\/a> sur SQL et JSON.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Introduction aux fonctions SQL Server natives JSON_VALUE, JSON_QUERY et JSON_MODIFY pour g\u00e9rer le format JSON. Dans le monde de la gestion des donn\u00e9es et de l&rsquo;informatique, y compris SQL Server, l&rsquo;utilisation de JSON (JavaScript Object Notation) est devenue de <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/\" title=\"Fonctions SQL Server JSON : exemples de requ\u00eates\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10732,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-27425","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>Fonctions SQL Server JSON : exemples de requ\u00eates - T-SQL<\/title>\n<meta name=\"description\" content=\"Utiliser le format standard JSON avec les fonctions natives SQL Server telles que JSON_VALUE, JSON_QUERY dans des exemples pratiques.\" \/>\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\/fr\/t-sql\/fonctions-sql-server-json\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonctions SQL Server JSON : exemples de requ\u00eates\" \/>\n<meta property=\"og:description\" content=\"Utiliser le format standard JSON avec les fonctions natives SQL Server telles que JSON_VALUE, JSON_QUERY dans des exemples pratiques.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\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:57:55+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=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Fonctions SQL Server JSON : exemples de requ\u00eates\",\"datePublished\":\"2023-08-01T05:11:00+00:00\",\"dateModified\":\"2023-10-09T17:57:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/\"},\"wordCount\":794,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/\",\"name\":\"Fonctions SQL Server JSON : exemples de requ\u00eates - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/#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:57:55+00:00\",\"description\":\"Utiliser le format standard JSON avec les fonctions natives SQL Server telles que JSON_VALUE, JSON_QUERY dans des exemples pratiques.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/#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\/fr\/t-sql\/fonctions-sql-server-json\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fonctions SQL Server JSON : exemples de requ\u00eates\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/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\/fr\/#\/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\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/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":"Fonctions SQL Server JSON : exemples de requ\u00eates - T-SQL","description":"Utiliser le format standard JSON avec les fonctions natives SQL Server telles que JSON_VALUE, JSON_QUERY dans des exemples pratiques.","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\/fr\/t-sql\/fonctions-sql-server-json\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonctions SQL Server JSON : exemples de requ\u00eates","og_description":"Utiliser le format standard JSON avec les fonctions natives SQL Server telles que JSON_VALUE, JSON_QUERY dans des exemples pratiques.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-08-01T05:11:00+00:00","article_modified_time":"2023-10-09T17:57:55+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":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Fonctions SQL Server JSON : exemples de requ\u00eates","datePublished":"2023-08-01T05:11:00+00:00","dateModified":"2023-10-09T17:57:55+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/"},"wordCount":794,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/","name":"Fonctions SQL Server JSON : exemples de requ\u00eates - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/#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:57:55+00:00","description":"Utiliser le format standard JSON avec les fonctions natives SQL Server telles que JSON_VALUE, JSON_QUERY dans des exemples pratiques.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/fonctions-sql-server-json\/#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\/fr\/t-sql\/fonctions-sql-server-json\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Fonctions SQL Server JSON : exemples de requ\u00eates"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/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\/fr\/#\/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\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/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\/fr\/wp-json\/wp\/v2\/posts\/27425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=27425"}],"version-history":[{"count":3,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/27425\/revisions"}],"predecessor-version":[{"id":27428,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/27425\/revisions\/27428"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10732"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=27425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=27425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=27425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}