{"id":6447,"date":"2022-11-21T07:27:37","date_gmt":"2022-11-21T06:27:37","guid":{"rendered":"https:\/\/expert-only.com\/?p=6447"},"modified":"2022-12-08T11:08:14","modified_gmt":"2022-12-08T10:08:14","slug":"sql-server-string-longer-than-8000-chars","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/","title":{"rendered":"SQL Server string longer than 8000 characters"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>How to manage SQL Server strings with more than 8000 characters without errors?<\/em><\/strong><\/h4>\n\n\n\n<p>Using SQL Server string longer than 8000 characters with VARCHAR and NVARCHAR fields and explicit lenght is not possible. Indeed the explicit declarations are limited to 8000 characters with SQL Server. Handle text fields longer than 8000 characters and you get the following message, The text, ntext, and image data types are invalid for local variables. However, here is a solution to get around this 8000 character limitation in T-SQL with SQL Server.<\/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\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#managing-sql-server-string-with-more-than-8000-characters\" >Managing SQL Server string with more than 8000 characters<\/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\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#the-text-ntext-and-image-data-types-are-invalid-for-local-variables-error\" >The text, ntext, and image data types are invalid for local variables error<\/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\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#ms-sql-string-longer-than-8000-characters-in-a-text-column\" >MS SQL string longer than 8000 characters in a TEXT column<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-managing-sql-server-string-with-more-than-8000-characters\"><span class=\"ez-toc-section\" id=\"managing-sql-server-string-with-more-than-8000-characters\"><\/span>Managing SQL Server string with more than 8000 characters<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>First of all, this error appears if you tried to declare an argument of type TEXT in a stored procedure as follows:<\/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 MY_PROCEDURE\n@Variable_Text TEXT\nAS\nBEGIN\nDECLARE @VARIABLE_TEXT TEXT -- The problem is in this line\nDECLARE @VARIABLE_VARCHAR VARCHAR(8000) -- Type VARCHAR limited to 8000 characters\n-- SQL CODE continuation of the Stored Procedure\n-- ETC.\nEND;\n<\/pre>\n\n\n\n<p>The solution to handle the SQL Server limitation of 8000 characters for a string is to use the VARCHAR(MAX) type. Secondly, Microsoft SQL Server does not allow the syntax seen above.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-text-ntext-and-image-data-types-are-invalid-for-local-variables-error\"><span class=\"ez-toc-section\" id=\"the-text-ntext-and-image-data-types-are-invalid-for-local-variables-error\"><\/span>The text, ntext, and image data types are invalid for local variables error<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In some time, the TEXT data type will disappear from the Microsoft DBMS as explained in the<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/data-types\/ntext-text-and-image-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener nofollow\"> official MS documentation page about ntext, text and image datatypes<\/a>. In order to avoid this problem you will have to use the <em><strong>NVARCHAR(MAX)<\/strong><\/em> type. It gives the possibility to store strings of variable length. And thus to contain strings higher than 8000 characters.<\/p>\n\n\n\n<p>Indeed, here is an example of SQL code in 3 steps to:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Delete the procedure if it exists.<\/li>\n\n\n\n<li>Create the temporary table.<\/li>\n\n\n\n<li>Create the stored procedure that uses the VARCHAR(MAX) data type.<\/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. Delete the stored procedure if it already exists in the SQL Server database\nIF EXISTS (\n\tSELECT name FROM sysobjects\n\tWHERE name = 'My_Procedure' AND type = 'P')\n\tDROP PROCEDURE My_Procedure;\nGO\n\n-- 2. Create the temporary target table using a field of type TEXT.\nCREATE TABLE #Temp_Table (\nVERY_LONG_FIELD TEXT\n);\n\n-- 3. create the SQL stored procedure that handles long text fields\nCREATE PROCEDURE MY_PROCEDURE\nAS\nBEGIN\n\tDECLARE @Varchar_Variable VARCHAR(MAX);\n\tDECLARE @i INTEGER;\n\tSET @Varchar_Variable = 'A';\n\tSET @i = 0;\n\tPRINT 'TEST ' + @Varchar_Variable;\n\t\n\tWHILE (@i &lt; 10000)\n\tBEGIN\n\t\tSET @Varchar_Variable = @Varchar_Variable + 'A';\n\t\tSET @i = @i + 1;\n\tEND\n\tPRINT @Varchar_Variable;\n\tINSERT INTO #Temp_Table VALUES (@Varchar_Variable);\nEND;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ms-sql-string-longer-than-8000-characters-in-a-text-column\"><\/span>MS SQL string longer than 8000 characters in a TEXT column<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Finally, this solution makes it possible to manipulate strings of considerable length. Note also that it is possible to use a field of type NVARCHAR(MAX) to store the result of the query.<\/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=\"\">-- The execution of the stored procedure seen above\nEXEC MY_PROCEDURE;\n\n-- The SELECT query to check the result\nSELECT VERY_LONG_FIELD\nFROM #Temp_Table;\n<\/pre>\n\n\n\n<p>Finally, this solution makes it possible to manipulate SQL Server string longer than 8000 characters. Note also that it is possible to use a field of <a href=\"https:\/\/renenyffenegger.ch\/notes\/development\/databases\/SQL-Server\/T-SQL\/data-types\/index\" target=\"_blank\" rel=\"noreferrer noopener\">type<\/a> NVARCHAR(MAX) to store the result of the query. To go further, it is also possible to <a href=\"https:\/\/expert-only.com\/en\/t-sql\/implicit-conversion-from-data-type-xml-to-nvarchar-error\/\">use the SQL Server XML format to transform XML content into text with separators<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>How to manage SQL Server strings with more than 8000 characters without errors? Using SQL Server string longer than 8000 characters with VARCHAR and NVARCHAR fields and explicit lenght is not possible. Indeed the explicit declarations are limited to <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/\" title=\"SQL Server string longer than 8000 characters\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":6058,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[454],"tags":[],"class_list":{"0":"post-6447","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>SQL Server string longer than 8000 characters - Varchar - T-SQL<\/title>\n<meta name=\"description\" content=\"How to handle SQL Server string longer than 8000 characters to avoid error Text, ntext, and image data types are invalid.\" \/>\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\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server string longer than 8000 characters\" \/>\n<meta property=\"og:description\" content=\"How to handle SQL Server string longer than 8000 characters to avoid error Text, ntext, and image data types are invalid.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\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-08T10:08:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/entrepreneur_dark_heavy-antique-typewriter-4DCBC2BD36D_1920x1080.jpeg\" \/>\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=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\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\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"SQL Server string longer than 8000 characters\",\"datePublished\":\"2022-11-21T06:27:37+00:00\",\"dateModified\":\"2022-12-08T10:08:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/\"},\"wordCount\":353,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/entrepreneur_dark_heavy-antique-typewriter-4DCBC2BD36D_1920x1080.jpeg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/\",\"url\":\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/\",\"name\":\"SQL Server string longer than 8000 characters - Varchar - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/entrepreneur_dark_heavy-antique-typewriter-4DCBC2BD36D_1920x1080.jpeg\",\"datePublished\":\"2022-11-21T06:27:37+00:00\",\"dateModified\":\"2022-12-08T10:08:14+00:00\",\"description\":\"How to handle SQL Server string longer than 8000 characters to avoid error Text, ntext, and image data types are invalid.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/entrepreneur_dark_heavy-antique-typewriter-4DCBC2BD36D_1920x1080.jpeg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/entrepreneur_dark_heavy-antique-typewriter-4DCBC2BD36D_1920x1080.jpeg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server string longer than 8000 characters\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/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\/en\/#\/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\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/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":"SQL Server string longer than 8000 characters - Varchar - T-SQL","description":"How to handle SQL Server string longer than 8000 characters to avoid error Text, ntext, and image data types are invalid.","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\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server string longer than 8000 characters","og_description":"How to handle SQL Server string longer than 8000 characters to avoid error Text, ntext, and image data types are invalid.","og_url":"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-11-21T06:27:37+00:00","article_modified_time":"2022-12-08T10:08:14+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/entrepreneur_dark_heavy-antique-typewriter-4DCBC2BD36D_1920x1080.jpeg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"SQL Server string longer than 8000 characters","datePublished":"2022-11-21T06:27:37+00:00","dateModified":"2022-12-08T10:08:14+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/"},"wordCount":353,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/entrepreneur_dark_heavy-antique-typewriter-4DCBC2BD36D_1920x1080.jpeg","articleSection":["T-SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/","url":"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/","name":"SQL Server string longer than 8000 characters - Varchar - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/entrepreneur_dark_heavy-antique-typewriter-4DCBC2BD36D_1920x1080.jpeg","datePublished":"2022-11-21T06:27:37+00:00","dateModified":"2022-12-08T10:08:14+00:00","description":"How to handle SQL Server string longer than 8000 characters to avoid error Text, ntext, and image data types are invalid.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/entrepreneur_dark_heavy-antique-typewriter-4DCBC2BD36D_1920x1080.jpeg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/entrepreneur_dark_heavy-antique-typewriter-4DCBC2BD36D_1920x1080.jpeg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/t-sql\/sql-server-string-longer-than-8000-chars\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"SQL Server string longer than 8000 characters"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/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\/en\/#\/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\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/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\/en\/wp-json\/wp\/v2\/posts\/6447","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=6447"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/6447\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/6058"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=6447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=6447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=6447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}