{"id":1021,"date":"2023-08-04T07:14:00","date_gmt":"2023-08-04T05:14:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1021"},"modified":"2023-10-21T21:16:27","modified_gmt":"2023-10-21T19:16:27","slug":"conversion-implicite-type-de-donnees-xml","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/","title":{"rendered":"Conversion implicite du type de donn\u00e9es XML en Nvarchar"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-center\"><strong><em>Comment \u00e9viter l&rsquo;erreur : la conversion implicite du type de donn\u00e9es XML en NVARCHAR n&rsquo;est pas autoris\u00e9e dans les scripts T-SQL ?<\/em><\/strong><\/h4>\n\n\n\n<p>Comment convertir une variable XML en VARCHAR et \u00e9viter les erreurs de conversion comme : Conversion implicite du type de donn\u00e9es XML, en T-SQL ? Avec SQL Server il est parfois int\u00e9ressant de mixer des colonnes num\u00e9riques avec des colonnes en XML pour une utilisation sp\u00e9ciale.<\/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\/conversion-implicite-type-de-donnees-xml\/#1-gerer-lerreur-sql-server-de-conversion-implicite-du-type-de-donnees-xml\" >1. G\u00e9rer l&rsquo;erreur SQL Server de conversion implicite du type de donn\u00e9es XML<\/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\/conversion-implicite-type-de-donnees-xml\/#2-convertir-une-colonne-xml-en-varchar-avec-la-fonction-sql-convert\" >2. Convertir une colonne XML en VARCHAR avec la fonction SQL CONVERT<\/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\/conversion-implicite-type-de-donnees-xml\/#3-exemple-de-code-t-sql-avec-plusieurs-balises-xml\" >3. Exemple de code T-SQL avec plusieurs balises XML<\/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\/conversion-implicite-type-de-donnees-xml\/#4-code-pour-convertir-le-xml-avec-chaque-balise-dans-une-colonne-differente\" >4. Code pour convertir le XML avec chaque balise dans une colonne diff\u00e9rente<\/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\/conversion-implicite-type-de-donnees-xml\/#5-conclusion-sur-la-conversion-xml-en-nvarchar-avec-t-sql\" >5. Conclusion sur la conversion XML en NVARCHAR avec T-SQL<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-gerer-l-erreur-sql-server-de-conversion-implicite-du-type-de-donnees-xml\"><span class=\"ez-toc-section\" id=\"1-gerer-lerreur-sql-server-de-conversion-implicite-du-type-de-donnees-xml\"><\/span>1. G\u00e9rer l&rsquo;erreur SQL Server de conversion implicite du type de donn\u00e9es XML<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En effet, pour faire une requ\u00eate plus facilement il est pratique de convertir la colonne de type XML en NVARCHAR pour pouvoir la filtrer avec les fonctions classiques. Cette requ\u00eate fonctionne aussi avec des colonnes <a href=\"https:\/\/en.wikibooks.org\/wiki\/XML_Schema\" target=\"_blank\" rel=\"noreferrer noopener\">XML bas\u00e9es sur un sch\u00e9ma<\/a>, qui est un format d&rsquo;\u00e9change de donn\u00e9es. Par exemple avec un bout de document XML basique, comme dans l&rsquo;exemple ci-dessous.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DECLARE @mon_xml XML;\nDECLARE @ma_chaine NVARCHAR(500);\n\nSET @mon_xml =\n'&lt;entreprise>\n\t&lt;employes>Hitachi&lt;\/employes>\n\t&lt;employes>Durant&lt;\/employes>\n\t&lt;employes>Marwani&lt;\/employes>\n&lt;\/entreprise>';\n\nSET @ma_chaine  = @mon_xml;\n\nSELECT @ma_chaine;\n<\/pre>\n\n\n\n<p>&nbsp;Un erreur est retourn\u00e9e par SQL Server :&nbsp;<em><strong>La conversion implicite du type de donn\u00e9es XML en NVARCHAR n&rsquo;est pas autoris\u00e9e.<\/strong> Utilisez la fonction CONVERT pour ex\u00e9cuter cette requ\u00eate.<\/em><\/p>\n\n\n\n<p>La m\u00eame erreur en Anglais :&nbsp;&nbsp;<em>Implicit conversion from data type XML to NVARCHAR is not allowed. Use the CONVERT function to run this query.<\/em><\/p>\n\n\n\n<p>Noter que ce message est g\u00e9n\u00e9rique et qu&rsquo;il concerne toutes les conversions entre types de donn\u00e9es non compatibles.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-convertir-une-colonne-xml-en-varchar-avec-la-fonction-sql-convert\"><span class=\"ez-toc-section\" id=\"2-convertir-une-colonne-xml-en-varchar-avec-la-fonction-sql-convert\"><\/span>2. Convertir une colonne XML en VARCHAR avec la fonction SQL CONVERT<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La solution est d&rsquo;utiliser la fonction SQL Server CONVERT du type XML vers le type NVARCHAR().&nbsp;Avec cette solution simple on peut effectuer une requ\u00eate sur des donn\u00e9es de type XML et m\u00eame faire une recherche avec les fonctions de filtre comme LIKE par exemple.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DECLARE @mon_xml XML;\nDECLARE @ma_chaine VARCHAR(500);\n\nSET @mon_xml =\n'&lt;entreprise>\n\t&lt;employes>Hitachi&lt;\/employes>\n\t&lt;employes>Durant&lt;\/employes>\n\t&lt;employes>Marwani&lt;\/employes>\n&lt;\/entreprise>';\n\nSET @ma_chaine = CONVERT(VARCHAR(500), @mon_xml);\n\nSELECT @ma_chaine as RESULTAT;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-exemple-de-code-t-sql-avec-plusieurs-balises-xml\"><\/span>3. Exemple de code T-SQL avec plusieurs balises XML<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Voici le m\u00eame exemple avec deux niveaux de balises XML imbriqu\u00e9es et les m\u00eames noms que votre exemple pr\u00e9c\u00e9dent :<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DECLARE @mon_xml XML;\nDECLARE @ma_chaine VARCHAR(500);\n\nSET @mon_xml =\n'&lt;entreprise>\n    &lt;employes>\n        &lt;nom>Hitachi&lt;\/nom>\n        &lt;age>35&lt;\/age>\n    &lt;\/employes>\n    &lt;employes>\n        &lt;nom>Durant&lt;\/nom>\n        &lt;age>28&lt;\/age>\n    &lt;\/employes>\n    &lt;employes>\n        &lt;nom>Marwani&lt;\/nom>\n        &lt;age>42&lt;\/age>\n    &lt;\/employes>\n&lt;\/entreprise>';\n\nSET @ma_chaine = CONVERT(VARCHAR(500), @mon_xml);\n\nSELECT @ma_chaine as RESULTAT;\n<\/pre>\n\n\n\n<p>Ce code d\u00e9finit une variable @mon_xml contenant des donn\u00e9es XML avec une balise racine et trois balises imbriqu\u00e9es, chacune contenant une balise et une balise . Le code convertit ensuite cette variable XML en une cha\u00eene de caract\u00e8res en utilisant la fonction CONVERT. Enfin, il s\u00e9lectionne la cha\u00eene r\u00e9sultante dans une colonne nomm\u00e9e RESULTAT.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-code-pour-convertir-le-xml-avec-chaque-balise-dans-une-colonne-differente\"><\/span>4. Code pour convertir le XML avec chaque balise dans une colonne diff\u00e9rente<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ce dernier exemple de code est plus complexe car il permet de convertir le format XML en VARCHAR mais aussi de s\u00e9parer chaque niveau de balise XML dans une colonne d\u00e9di\u00e9e. Voici donc l&rsquo;explication \u00e9tape par \u00e9tape de la requ\u00eate T-SQL ci-dessous :<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>La premi\u00e8re ligne d\u00e9clare une variable nomm\u00e9e \u00ab\u00a0@mon_xml\u00a0\u00bb avec le type \u00ab\u00a0XML\u00a0\u00bb. Cette variable est utilis\u00e9e pour stocker le contenu XML.<\/li>\n\n\n\n<li>La deuxi\u00e8me ligne d\u00e9clare une variable nomm\u00e9e \u00ab\u00a0@ma_chaine\u00a0\u00bb avec le type \u00ab\u00a0VARCHAR(MAX)\u00a0\u00bb. Cette variable est utilis\u00e9e pour stocker une cha\u00eene de caract\u00e8res qui repr\u00e9sente l&rsquo;objet XML stock\u00e9 dans la variable \u00ab\u00a0@mon_xml\u00a0\u00bb.<\/li>\n\n\n\n<li>La troisi\u00e8me ligne contient le contenu XML qui doit \u00eatre stock\u00e9. Il s&rsquo;agit d&rsquo;un exemple d&rsquo;une entreprise avec deux d\u00e9partements et plusieurs employ\u00e9s. Chaque employ\u00e9 a un nom, un pr\u00e9nom et un poste.<\/li>\n\n\n\n<li>La quatri\u00e8me ligne utilise la fonction \u00ab\u00a0CONVERT\u00a0\u00bb pour convertir l&rsquo;objet XML stock\u00e9 dans la variable \u00ab\u00a0@mon_xml\u00a0\u00bb en une cha\u00eene de caract\u00e8res stock\u00e9e dans la variable \u00ab\u00a0@ma_chaine\u00a0\u00bb.<\/li>\n\n\n\n<li>La cinqui\u00e8me ligne utilise la commande \u00ab\u00a0SELECT\u00a0\u00bb pour afficher la variable \u00ab\u00a0@ma_chaine\u00a0\u00bb qui contient le contenu XML sous forme de cha\u00eene de caract\u00e8res.<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DECLARE @mon_xml XML;\nDECLARE @ma_chaine VARCHAR(MAX);\n\nSET @mon_xml = '\n&lt;entreprise>\n\t&lt;nom>Expert-Only Inc.&lt;\/nom>\n\t&lt;departements>\n\t\t&lt;departement>\n\t\t\t&lt;nom>Marketing&lt;\/nom>\n\t\t\t&lt;employes>\n\t\t\t\t&lt;employe>\n\t\t\t\t\t&lt;nom>Hitachi&lt;\/nom>\n\t\t\t\t\t&lt;prenom>Paul&lt;\/prenom>\n\t\t\t\t\t&lt;poste>Charg\u00e9 de communication&lt;\/poste>\n\t\t\t\t&lt;\/employe>\n\t\t\t\t&lt;employe>\n\t\t\t\t\t&lt;nom>Durant&lt;\/nom>\n\t\t\t\t\t&lt;prenom>Marie&lt;\/prenom>\n\t\t\t\t\t&lt;poste>Assistante marketing&lt;\/poste>\n\t\t\t\t&lt;\/employe>\n\t\t\t&lt;\/employes>\n\t\t&lt;\/departement>\n\t\t&lt;departement>\n\t\t\t&lt;nom>Comptabilit\u00e9&lt;\/nom>\n\t\t\t&lt;employes>\n\t\t\t\t&lt;employe>\n\t\t\t\t\t&lt;nom>Marwani&lt;\/nom>\n\t\t\t\t\t&lt;prenom>John&lt;\/prenom>\n\t\t\t\t\t&lt;poste>Comptable&lt;\/poste>\n\t\t\t\t&lt;\/employe>\n\t\t\t\t&lt;employe>\n\t\t\t\t\t&lt;nom>Ahmedi&lt;\/nom>\n\t\t\t\t\t&lt;prenom>Emily&lt;\/prenom>\n\t\t\t\t\t&lt;poste>Assistante comptable&lt;\/poste>\n\t\t\t\t&lt;\/employe>\n\t\t\t&lt;\/employes>\n\t\t&lt;\/departement>\n\t&lt;\/departements>\n&lt;\/entreprise>';\n\nSELECT\n    T.c.value('nom[1]', 'VARCHAR(MAX)') AS Nom,\n    D.c.value('nom[1]', 'VARCHAR(MAX)') AS NomDepartement,\n    E.c.value('nom[1]', 'VARCHAR(MAX)') AS NomEmploye,\n    E.c.value('prenom[1]', 'VARCHAR(MAX)') AS PrenomEmploye,\n    E.c.value('poste[1]', 'VARCHAR(MAX)') AS PosteEmploye\nFROM @mon_xml.nodes('entreprise') T(c)\n\tCROSS APPLY T.c.nodes('departements\/departement') D(c)\n\tCROSS APPLY D.c.nodes('employes\/employe') E(c);\n<\/pre>\n\n\n\n<p>Le r\u00e9sultat de la requ\u00eate est donc le suivant:<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><th>Entreprise<\/th><th>D\u00e9partement<\/th><th>Nom<\/th><th>Pr\u00e9nom<\/th><th>Poste<\/th><\/tr><tr><td>Expert-Only Inc.<\/td><td>Marketing<\/td><td>Hitachi<\/td><td>Paul<\/td><td>Charg\u00e9 de communication<\/td><\/tr><tr><td>Expert-Only Inc.<\/td><td>Marketing<\/td><td>Durant<\/td><td>Marie<\/td><td>Assistante marketing<\/td><\/tr><tr><td>Expert-Only Inc.<\/td><td>Comptabilit\u00e9<\/td><td>Marwani<\/td><td>John<\/td><td>Comptable<\/td><\/tr><tr><td>Expert-Only Inc.<\/td><td>Comptabilit\u00e9<\/td><td>Ahmedi<\/td><td>Emily<\/td><td>Assistante comptable<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-conclusion-sur-la-conversion-xml-en-nvarchar-avec-t-sql\"><\/span>5. Conclusion sur la conversion XML en NVARCHAR avec T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En conclusion, ce tutoriel explique comment convertir une variable T-SQL de type XML en cha\u00eene de caract\u00e8res et \u00e9viter les erreurs de conversion implicite de type de donn\u00e9es.<\/p>\n\n\n\n<p>En effet, cet article explique comment transformer facilement une colonne ou une variable stock\u00e9e au format XML. Vers une variable en NVARCHAR. Le XML est utilis\u00e9 en T-SQL pour s\u00e9parer des parties de texte avec s\u00e9parateurs. Par exemple, cet exemple de script Transact-SQL permet de <a href=\"https:\/\/expert-only.com\/tsql\/decouper-chaine-sql-server-separateur-plusieurs-lignes\/\">d\u00e9couper une cha\u00eene de caract\u00e8re avec s\u00e9parateurs en plusieurs lignes<\/a>.<\/p>\n\n\n\n<p>La conversion d&rsquo;une colonne de type XML en NVARCHAR avec la fonction CONVERT permet de requ\u00eater facilement des donn\u00e9es XML en utilisant des fonctions de filtre comme LIKE, par exemple. Le tutoriel fournit \u00e9galement des exemples de code T-SQL avec plusieurs niveaux de balises XML imbriqu\u00e9es et l&rsquo;affichage des balises dans des colonnes diff\u00e9rentes.<\/p>\n\n\n\n<p>Enfin, le XML est utilis\u00e9 en T-SQL pour s\u00e9parer des parties de texte avec des s\u00e9parateurs et permet de d\u00e9couper une cha\u00eene de caract\u00e8re en plusieurs lignes en utilisant une fonction XML disponible avec SQL Server.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment \u00e9viter l&rsquo;erreur : la conversion implicite du type de donn\u00e9es XML en NVARCHAR n&rsquo;est pas autoris\u00e9e dans les scripts T-SQL ? Comment convertir une variable XML en VARCHAR et \u00e9viter les erreurs de conversion comme : Conversion implicite <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/\" title=\"Conversion implicite du type de donn\u00e9es XML en Nvarchar\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10637,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-1021","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>Conversion implicite du type de donn\u00e9es XML en Nvarchar - T-SQL<\/title>\n<meta name=\"description\" content=\"Comment \u00e9viter l&#039;erreur Conversion implicite du type de donn\u00e9es XML en NVARCHAR avec SQL Server ? Exemple de CONVERT pour convertir du XML.\" \/>\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\/conversion-implicite-type-de-donnees-xml\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Conversion implicite du type de donn\u00e9es XML en Nvarchar\" \/>\n<meta property=\"og:description\" content=\"Comment \u00e9viter l&#039;erreur Conversion implicite du type de donn\u00e9es XML en NVARCHAR avec SQL Server ? Exemple de CONVERT pour convertir du XML.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/\" \/>\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-04T05:14:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-21T19:16:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/empty-notebook-painting-1614436D220_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\/conversion-implicite-type-de-donnees-xml\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Conversion implicite du type de donn\u00e9es XML en Nvarchar\",\"datePublished\":\"2023-08-04T05:14:00+00:00\",\"dateModified\":\"2023-10-21T19:16:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/\"},\"wordCount\":884,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/empty-notebook-painting-1614436D220_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/\",\"name\":\"Conversion implicite du type de donn\u00e9es XML en Nvarchar - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/empty-notebook-painting-1614436D220_1920x1080.jpg\",\"datePublished\":\"2023-08-04T05:14:00+00:00\",\"dateModified\":\"2023-10-21T19:16:27+00:00\",\"description\":\"Comment \u00e9viter l'erreur Conversion implicite du type de donn\u00e9es XML en NVARCHAR avec SQL Server ? Exemple de CONVERT pour convertir du XML.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/empty-notebook-painting-1614436D220_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/empty-notebook-painting-1614436D220_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Conversion implicite du type de donn\u00e9es XML en Nvarchar\"}]},{\"@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":"Conversion implicite du type de donn\u00e9es XML en Nvarchar - T-SQL","description":"Comment \u00e9viter l'erreur Conversion implicite du type de donn\u00e9es XML en NVARCHAR avec SQL Server ? Exemple de CONVERT pour convertir du XML.","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\/conversion-implicite-type-de-donnees-xml\/","og_locale":"fr_FR","og_type":"article","og_title":"Conversion implicite du type de donn\u00e9es XML en Nvarchar","og_description":"Comment \u00e9viter l'erreur Conversion implicite du type de donn\u00e9es XML en NVARCHAR avec SQL Server ? Exemple de CONVERT pour convertir du XML.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-08-04T05:14:00+00:00","article_modified_time":"2023-10-21T19:16:27+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/empty-notebook-painting-1614436D220_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\/conversion-implicite-type-de-donnees-xml\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Conversion implicite du type de donn\u00e9es XML en Nvarchar","datePublished":"2023-08-04T05:14:00+00:00","dateModified":"2023-10-21T19:16:27+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/"},"wordCount":884,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/empty-notebook-painting-1614436D220_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/","name":"Conversion implicite du type de donn\u00e9es XML en Nvarchar - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/empty-notebook-painting-1614436D220_1920x1080.jpg","datePublished":"2023-08-04T05:14:00+00:00","dateModified":"2023-10-21T19:16:27+00:00","description":"Comment \u00e9viter l'erreur Conversion implicite du type de donn\u00e9es XML en NVARCHAR avec SQL Server ? Exemple de CONVERT pour convertir du XML.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/empty-notebook-painting-1614436D220_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/empty-notebook-painting-1614436D220_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/conversion-implicite-type-de-donnees-xml\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Conversion implicite du type de donn\u00e9es XML en Nvarchar"}]},{"@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\/1021","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=1021"}],"version-history":[{"count":1,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1021\/revisions"}],"predecessor-version":[{"id":27632,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1021\/revisions\/27632"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10637"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}