{"id":941,"date":"2022-11-21T07:27:37","date_gmt":"2022-11-21T06:27:37","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=941"},"modified":"2022-12-07T18:27:48","modified_gmt":"2022-12-07T17:27:48","slug":"textes-sql-server-plus-de-8000-caracteres","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/","title":{"rendered":"Textes SQL Server de plus de 8000 caract\u00e8res"},"content":{"rendered":"\n<p>Comment g\u00e9rer les champs textes SQL Server de plus de 8000 caract\u00e8res sans erreur ? Les champs VARCHAR et NVARCHAR sont limit\u00e9s \u00e0 8000 caract\u00e8res avec SQL Server. Manipuler des champs textes sup\u00e9rieurs \u00e0 8000 caract\u00e8res et le message suivant s&rsquo;affiche : The text, ntext, and image data types are invalid for local variables.. Voici donc une solution pour contourner cette limitation des 8000 caract\u00e8res en T-SQL avec SQL Server.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Erreur SQL Server : The text, ntext, and image data types are invalid for local variables.<\/h2>\n\n\n\n<p>Premi\u00e8rement, cette erreur s\u2019affiche si vous avez essay\u00e9s de d\u00e9clarer un argument du type TEXT dans une proc\u00e9dure stock\u00e9e de la mani\u00e8re suivante.<\/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=\"\">CREATE PROCEDURE MA_PROCEDURE\n@Variable_Text TEXT\nAS\nBEGIN\nDECLARE @VARIABLE_TEXT TEXT -- Ligne posant probl\u00e8me\nDECLARE @VARIABLE_VARCHAR VARCHAR(8000) -- Type VARCHAR limit\u00e9 \u00e0 8000 caract\u00e8res\n-- Suite du CODE SQL de la Proc\u00e9dure stock\u00e9e\n-- ETC.\nEND;\n<\/pre>\n\n\n\n<p id=\"h-le-message-d-erreur-en-fran-ais-les-types-de-donn-es-text-ntext-et-image-ne-sont-pas-valides-pour-les-variables-locales\">Le message d&rsquo;erreur en Fran\u00e7ais : <\/p>\n\n\n\n<p id=\"h-le-message-d-erreur-en-fran-ais-les-types-de-donn-es-text-ntext-et-image-ne-sont-pas-valides-pour-les-variables-locales\"><strong><em>Les types de donn\u00e9es text, ntext et image ne sont pas valides pour les variables locales.<\/em><\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-eviter-la-limite-ms-sql-a-8000-caracteres-avec-varchar-max\">Eviter la limite MS SQL \u00e0 8000 caract\u00e8res avec VARCHAR(MAX)<\/h2>\n\n\n\n<p>Deuxi\u00e8mement, Microsoft SQL Server n&rsquo;autorise pas la syntaxe vue ci-dessus. Dans quelques temps, le type TEXT disparaitra du SGBD de Microsoft. Afin d\u2019\u00e9viter ce probl\u00e8me il vous faudra utiliser le type NVARCHAR(MAX). Il donne la possibilit\u00e9 de se stocker des cha\u00eenes de longueurs variables. Et ainsi de contenir des <a href=\"https:\/\/learn.microsoft.com\/fr-fr\/sql\/t-sql\/functions\/string-functions-transact-sql?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">cha\u00eenes de caract\u00e8res<\/a> sup\u00e9rieures \u00e0 8000 caract\u00e8res.<\/p>\n\n\n\n<p>En effet, voici un exemple de code SQL en 3 \u00e9tapes pour:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Supprimer la proc\u00e9dure si elle existe.<\/li>\n\n\n\n<li>Cr\u00e9er la table temporaire.<\/li>\n\n\n\n<li>Cr\u00e9er la proc\u00e9dure stock\u00e9e qui utilise le type de donn\u00e9es VARCHAR(MAX)<\/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=\"\">-- 1. Supprimer la proc\u00e9dure stock\u00e9e si elle existe d\u00e9j\u00e0 dans la base SQL Server\nIF EXISTS (\nSELECT name FROM sysobjects\nWHERE name = 'MA_PROCEDURE' AND type = 'P')\nDROP PROCEDURE MA_PROCEDURE;\nGO\n\n-- 2. Cr\u00e9er la table cible temporaire \u00e0 l\u2019aide un champ de type TEXT.\nCREATE TABLE #TABLE_TEMPORAIRE (\nTRES_LONG_CHAMP TEXT\n);\n\n-- 3. Cr\u00e9er la proc\u00e9dure stock\u00e9e SQL qui g\u00e8re les longs champs textes\nCREATE PROCEDURE MA_PROCEDURE\nAS\nBEGIN\nDECLARE @VARIABLE_VARCHAR VARCHAR(MAX);\nDECLARE @COMPTEUR INTEGER;\n\nSET @VARIABLE_VARCHAR = 'A';\nSET @COMPTEUR = 0;\nPRINT 'TEST ' + @VARIABLE_VARCHAR;\nWHILE (@COMPTEUR &lt; 10000)\nBEGIN\nSET @VARIABLE_VARCHAR = @VARIABLE_VARCHAR + 'A';\nSET @COMPTEUR = @COMPTEUR + 1;\nEND\n\nPRINT @VARIABLE_VARCHAR;\nINSERT INTO #TABLE_TEMPORAIRE VALUES (@VARIABLE_VARCHAR);\nEND;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-texte-de-plus-de-8000-caracteres-dans-une-colonne-de-type-text\">Texte de plus de 8000 caract\u00e8res dans une colonne de type TEXT<\/h2>\n\n\n\n<p>Enfin, cette solution permet de manipuler des champs de texte d\u2019une longueur cons\u00e9quente. A noter \u00e9galement qu&rsquo;il est possible d&rsquo;utiliser un champ de <a href=\"https:\/\/wiki.ispirer.com\/sqlways\/sql-server\/data-types\/nvarchar_n\" target=\"_blank\" rel=\"noreferrer noopener\">type<\/a> NVARCHAR(MAX) pour stocker le r\u00e9sultat de la requ\u00eate.<\/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=\"\">-- L\u2019ex\u00e9cution de la proc\u00e9dure stock\u00e9e vu un peu plus haut\nEXEC MA_PROCEDURE;\n\n-- La requ\u00eate SELECT afin d\u2019effectuer la v\u00e9rification du r\u00e9sultat\nSELECT TRES_LONG_CHAMP\nFROM #TABLE_TEMPORAIRE\n<\/pre>\n\n\n\n<p>Ce code permet donc de textes SQL Server de plus de 8000 caract\u00e8res pour \u00e9viter les erreurs d&rsquo;incompatibilit\u00e9 des types de donn\u00e9es. Pour aller plus loin, il est aussi possible d&rsquo;<a href=\"https:\/\/expert-only.com\/transact-sql\/conversion-implicite-du-type-de-donnees-xml-en-nvarchar\/\">utiliser le format SQL Server XML pour transformer du contenu XML en texte avec s\u00e9parateur.<\/a><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/expert-only.com\/t-sql\/conversion-implicite-du-type-de-donnees-xml\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment g\u00e9rer les champs textes SQL Server de plus de 8000 caract\u00e8res sans erreur ? Les champs VARCHAR et NVARCHAR sont limit\u00e9s \u00e0 8000 caract\u00e8res avec SQL Server. Manipuler des champs textes sup\u00e9rieurs \u00e0 8000 caract\u00e8res et le message <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/\" title=\"Textes SQL Server de plus de 8000 caract\u00e8res\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10662,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-941","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>Textes SQL Server de plus de 8000 caract\u00e8res - Varchar - T-SQL<\/title>\n<meta name=\"description\" content=\"G\u00e9rer les textes SQL Server de plus de 8000 caract\u00e8res et \u00e9viter l&#039;erreur Les types de donn\u00e9es text, ntext et image ne sont pas valides.\" \/>\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\/textes-sql-server-plus-de-8000-caracteres\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Textes SQL Server de plus de 8000 caract\u00e8res\" \/>\n<meta property=\"og:description\" content=\"G\u00e9rer les textes SQL Server de plus de 8000 caract\u00e8res et \u00e9viter l&#039;erreur Les types de donn\u00e9es text, ntext et image ne sont pas valides.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/\" \/>\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=\"2022-11-21T06:27:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-07T17:27:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_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=\"3 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\/textes-sql-server-plus-de-8000-caracteres\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Textes SQL Server de plus de 8000 caract\u00e8res\",\"datePublished\":\"2022-11-21T06:27:37+00:00\",\"dateModified\":\"2022-12-07T17:27:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/\"},\"wordCount\":365,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/\",\"name\":\"Textes SQL Server de plus de 8000 caract\u00e8res - Varchar - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_1920x1080.jpg\",\"datePublished\":\"2022-11-21T06:27:37+00:00\",\"dateModified\":\"2022-12-07T17:27:48+00:00\",\"description\":\"G\u00e9rer les textes SQL Server de plus de 8000 caract\u00e8res et \u00e9viter l'erreur Les types de donn\u00e9es text, ntext et image ne sont pas valides.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Textes SQL Server de plus de 8000 caract\u00e8res\"}]},{\"@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":"Textes SQL Server de plus de 8000 caract\u00e8res - Varchar - T-SQL","description":"G\u00e9rer les textes SQL Server de plus de 8000 caract\u00e8res et \u00e9viter l'erreur Les types de donn\u00e9es text, ntext et image ne sont pas valides.","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\/textes-sql-server-plus-de-8000-caracteres\/","og_locale":"fr_FR","og_type":"article","og_title":"Textes SQL Server de plus de 8000 caract\u00e8res","og_description":"G\u00e9rer les textes SQL Server de plus de 8000 caract\u00e8res et \u00e9viter l'erreur Les types de donn\u00e9es text, ntext et image ne sont pas valides.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-11-21T06:27:37+00:00","article_modified_time":"2022-12-07T17:27:48+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Textes SQL Server de plus de 8000 caract\u00e8res","datePublished":"2022-11-21T06:27:37+00:00","dateModified":"2022-12-07T17:27:48+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/"},"wordCount":365,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/","name":"Textes SQL Server de plus de 8000 caract\u00e8res - Varchar - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_1920x1080.jpg","datePublished":"2022-11-21T06:27:37+00:00","dateModified":"2022-12-07T17:27:48+00:00","description":"G\u00e9rer les textes SQL Server de plus de 8000 caract\u00e8res et \u00e9viter l'erreur Les types de donn\u00e9es text, ntext et image ne sont pas valides.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Textes SQL Server de plus de 8000 caract\u00e8res"}]},{"@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\/941","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=941"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/941\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10662"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=941"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}