{"id":30433,"date":"2024-03-01T06:38:00","date_gmt":"2024-03-01T05:38:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=30433"},"modified":"2024-03-04T13:10:31","modified_gmt":"2024-03-04T12:10:31","slug":"dividir-texto-delimitado-en-lineas-con-sql-server-string-split","status":"publish","type":"post","link":"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/","title":{"rendered":"Dividir texto delimitado en l\u00edneas con SQL Server STRING_SPLIT"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\" id=\"h-la-funcionalidad-para-dividir-texto-delimitado-en-diferentes-lineas-esta-disponible-de-forma-nativa-desde-sql-server-2016-en-adelante\">La funcionalidad para dividir texto delimitado en diferentes l\u00edneas est\u00e1 disponible de forma nativa desde SQL Server 2016 en adelante.<\/h4>\n\n\n\n<p>Para dividir texto delimitado en varias l\u00edneas con SQL Server, he estado utilizando <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/functions\/string-split-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">funciones definidas por el usuario de T-SQL<\/a> durante a\u00f1os antes de que saliera la versi\u00f3n de SQL Server 2016. De hecho, a partir de <strong>SQL Server 2016<\/strong> una nueva funci\u00f3n integrada permite esta caracter\u00edstica. Es la <strong>funci\u00f3n STRING_SPLIT de T-SQL<\/strong>.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#1-valores-simples-separados-por-comas-con-string-split\" >1. Valores simples separados por comas con STRING_SPLIT<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#2-analizar-texto-con-separador-de-punto-y-coma-en-lineas-con-sql-server\" >2. Analizar texto con separador de punto y coma en l\u00edneas con SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#3-dividir-una-cadena-de-una-variable-en-varias-filas-con-t-sql\" >3. Dividir una cadena de una variable en varias filas con T-SQL<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-valores-simples-separados-por-comas-con-string-split\"><span class=\"ez-toc-section\" id=\"1-valores-simples-separados-por-comas-con-string-split\"><\/span>1. Valores simples separados por comas con STRING_SPLIT<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Para este primer ejemplo, un caso de uso com\u00fan para STRING_SPLIT es <a href=\"https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/String\/split\" target=\"_blank\" rel=\"noreferrer noopener\">dividir<\/a> una cadena de valores separados por comas (CSV) en filas individuales.<\/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 value\nFROM STRING_SPLIT('Manzana,Naranja,Pl\u00e1tano,Uvas,Mango', ','); \n\n-- Usa el segundo ejemplo para renombrar la columna\nSELECT value as Fruta\nFROM STRING_SPLIT('Manzana,Naranja,Pl\u00e1tano,Uvas,Mango', ','); \n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"600\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/split-text-separator-in-lines-sql-server-string-split.jpg\" alt=\"Divide un texto delimitado por separador en varias l\u00edneas con SQL Server STRING_SPLIT \" class=\"wp-image-30422\" style=\"width:680px;height:auto\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/split-text-separator-in-lines-sql-server-string-split.jpg 680w, https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/split-text-separator-in-lines-sql-server-string-split-300x265.jpg 300w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><figcaption class=\"wp-element-caption\"><em>Divide un texto delimitado por separador en varias l\u00edneas con SQL Server STRING_SPLIT <\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-analizar-texto-con-separador-de-punto-y-coma-en-lineas-con-sql-server\"><span class=\"ez-toc-section\" id=\"2-analizar-texto-con-separador-de-punto-y-coma-en-lineas-con-sql-server\"><\/span>2. Analizar texto con separador de punto y coma en l\u00edneas con SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Otra aplicaci\u00f3n pr\u00e1ctica es dividir una cadena de correos electr\u00f3nicos separados por punto y coma en filas individuales.<\/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 value as [Correo electr\u00f3nico]\nFROM STRING_SPLIT('ejemplo1@email.com;ejemplo2@email.com;ejemplo3@email.com', ';')<\/pre>\n\n\n\n<p>Esto devolver\u00e1 una tabla donde cada fila contiene una \u00fanica direcci\u00f3n de correo electr\u00f3nico de la cadena original.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-dividir-una-cadena-de-una-variable-en-varias-filas-con-t-sql\"><\/span>3. Dividir una cadena de una variable en varias filas con T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En este tercer ejemplo, utilizamos ciudades. El objetivo es lograr el mismo resultado pero utilizando variables para almacenar la cadena y el separador. El c\u00f3digo es m\u00e1s flexible y podr\u00eda manejar datos provenientes de una tabla, por ejemplo.<\/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=\"\">-- Declaraci\u00f3n de variables\nDECLARE \n@String nvarchar(max), \n@Separator char(1);\n\n-- Inicializaci\u00f3n de la cadena y el Separador\nSET @String = 'Nueva York;Los \u00c1ngeles;Chicago;Houston;Phoenix;Filadelfia;San Antonio;San Diego;Dallas;San Jos\u00e9';\nSET @Separator = ';';\n\n-- Usa la funci\u00f3n de dividir cadena aqu\u00ed en lugar de la soluci\u00f3n XML\nSELECT @String = STRING_SPLIT ( @String , @Separator );\n<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-acerca-de-la-funcion-string-split-de-t-sql\">Acerca de la funci\u00f3n STRING_SPLIT de T-SQL<\/h3>\n\n\n\n<p>La funci\u00f3n STRING_SPLIT en T-SQL es una herramienta poderosa para la manipulaci\u00f3n de texto, permitiendo de dividir texto delimitado en l\u00edneas con SQL Server. Ya sea manejando datos CSV o analizando cadenas complejas, STRING_SPLIT proporciona una soluci\u00f3n sencilla para convertir texto delimitado en l\u00edneas separadas. Su simplicidad y eficacia la hacen una caracter\u00edstica esencial para desarrolladores y administradores de bases de datos que se ocupan de tareas de procesamiento de texto y transformaci\u00f3n de datos.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\" id=\"h-dividir-una-cadena-con-delimitadores-en-multiples-columnas\">Dividir una cadena con delimitadores en m\u00faltiples columnas<\/h5>\n\n\n\n<p>\u00bfQu\u00e9 pasa si necesitas almacenar cada valor en una columna separada, por ejemplo, para preparar la <a href=\"https:\/\/expert-only.com\/en\/ssis\/export-sql-data-in-csv-with-ssis\/\">importaci\u00f3n de archivos csv con un encabezado<\/a>? Aqu\u00ed hay otro tutorial con un ejemplo de c\u00f3mo seleccionar cada valor de la variable @String en columnas dedicadas separadas. Tutorial completo sobre c\u00f3mo <a style=\"font-weight: bold;\" href=\"https:\/\/expert-only.com\/en\/t-sql\/split-text-into-columns-sql-server\/\">Dividir texto delimitado en columnas en SQL Server<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-tutoriales-de-sql-y-ti wp-block-embed-tutoriales-de-sql-y-ti\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"ooOjA2kz28\"><a href=\"https:\/\/expert-only.com\/en\/t-sql\/split-text-into-columns-sql-server\/\">Split delimited text into columns in SQL Server<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00abSplit delimited text into columns in SQL Server\u00bb \u2014 Tutoriales de SQL y TI\" src=\"https:\/\/expert-only.com\/en\/t-sql\/split-text-into-columns-sql-server\/embed\/#?secret=kwTLGQeVbS#?secret=ooOjA2kz28\" data-secret=\"ooOjA2kz28\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>La funcionalidad para dividir texto delimitado en diferentes l\u00edneas est\u00e1 disponible de forma nativa desde SQL Server 2016 en adelante. Para dividir texto delimitado en varias l\u00edneas con SQL Server, he estado utilizando funciones definidas por el usuario de <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/\" title=\"Dividir texto delimitado en l\u00edneas con SQL Server STRING_SPLIT\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10816,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[455],"tags":[],"class_list":{"0":"post-30433","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>Dividir texto delimitado en l\u00edneas con SQL Server STRING_SPLIT<\/title>\n<meta name=\"description\" content=\"Para dividir un texto delimitado en l\u00edneas con SQL Server 2016 y versiones posteriores, utilice la funci\u00f3n STRING_SPLIT en T-SQL.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dividir texto delimitado en l\u00edneas con SQL Server STRING_SPLIT\" \/>\n<meta property=\"og:description\" content=\"Para dividir un texto delimitado en l\u00edneas con SQL Server 2016 y versiones posteriores, utilice la funci\u00f3n STRING_SPLIT en T-SQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriales de SQL y TI\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-01T05:38:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-04T12:10:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Dividir texto delimitado en l\u00edneas con SQL Server STRING_SPLIT\",\"datePublished\":\"2024-03-01T05:38:00+00:00\",\"dateModified\":\"2024-03-04T12:10:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/\"},\"wordCount\":411,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/es\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/\",\"url\":\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/\",\"name\":\"Dividir texto delimitado en l\u00edneas con SQL Server STRING_SPLIT\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg\",\"datePublished\":\"2024-03-01T05:38:00+00:00\",\"dateModified\":\"2024-03-04T12:10:31+00:00\",\"description\":\"Para dividir un texto delimitado en l\u00edneas con SQL Server 2016 y versiones posteriores, utilice la funci\u00f3n STRING_SPLIT en T-SQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"es\",\"item\":\"https:\/\/expert-only.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dividir texto delimitado en l\u00edneas con SQL Server STRING_SPLIT\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/es\/#website\",\"url\":\"https:\/\/expert-only.com\/es\/\",\"name\":\"Tutoriales de SQL y TI\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/es\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Dividir texto delimitado en l\u00edneas con SQL Server STRING_SPLIT","description":"Para dividir un texto delimitado en l\u00edneas con SQL Server 2016 y versiones posteriores, utilice la funci\u00f3n STRING_SPLIT en T-SQL.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/","og_locale":"es_ES","og_type":"article","og_title":"Dividir texto delimitado en l\u00edneas con SQL Server STRING_SPLIT","og_description":"Para dividir un texto delimitado en l\u00edneas con SQL Server 2016 y versiones posteriores, utilice la funci\u00f3n STRING_SPLIT en T-SQL.","og_url":"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/","og_site_name":"Tutoriales de SQL y TI","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-03-01T05:38:00+00:00","article_modified_time":"2024-03-04T12:10:31+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Escrito por":"Expert-Only","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Dividir texto delimitado en l\u00edneas con SQL Server STRING_SPLIT","datePublished":"2024-03-01T05:38:00+00:00","dateModified":"2024-03-04T12:10:31+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/"},"wordCount":411,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/es\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/","url":"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/","name":"Dividir texto delimitado en l\u00edneas con SQL Server STRING_SPLIT","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg","datePublished":"2024-03-01T05:38:00+00:00","dateModified":"2024-03-04T12:10:31+00:00","description":"Para dividir un texto delimitado en l\u00edneas con SQL Server 2016 y versiones posteriores, utilice la funci\u00f3n STRING_SPLIT en T-SQL.","breadcrumb":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/es\/t-sql\/dividir-texto-delimitado-en-lineas-con-sql-server-string-split\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"es","item":"https:\/\/expert-only.com\/es\/"},{"@type":"ListItem","position":2,"name":"Dividir texto delimitado en l\u00edneas con SQL Server STRING_SPLIT"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/es\/#website","url":"https:\/\/expert-only.com\/es\/","name":"Tutoriales de SQL y TI","description":"","publisher":{"@id":"https:\/\/expert-only.com\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/es\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/es\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/30433","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/comments?post=30433"}],"version-history":[{"count":4,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/30433\/revisions"}],"predecessor-version":[{"id":30444,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/30433\/revisions\/30444"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media\/10816"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media?parent=30433"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/categories?post=30433"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/tags?post=30433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}