{"id":145,"date":"2017-09-18T21:50:01","date_gmt":"2017-09-18T21:50:01","guid":{"rendered":"http:\/\/www.manualsqlserver.com\/?p=145"},"modified":"2020-05-20T02:26:14","modified_gmt":"2020-05-20T02:26:14","slug":"tablas-campo-xml-ejemplo","status":"publish","type":"post","link":"https:\/\/manualsqlserver.com\/?p=145","title":{"rendered":"Tablas con campo XML ejemplo"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_000.png\" alt=\"\" class=\"wp-image-1244\" width=\"248\" height=\"272\"\/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>Campos XML en Tablas<\/strong><\/h1>\n\n\n\n<p>Los tipos de campo XML&nbsp;permiten guardar informaci\u00f3n estructurada que dependa del mismo registro. El uso de los tipos de datos XML es muy efectivo para elementos dependientes que no tengan muchos datos.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Ejemplo: Asegurado y los Dependientes<\/h3>\n\n\n\n<!--more-->\n\n\n\n<p><strong>En este ejemplo el tipo de campo XML almacenar\u00e1 los datos de los dependientes de un asegurado.<\/strong><\/p>\n\n\n\n<p><strong>La tabla Asegurados tiene un campo Dependientes de tipo XML llamado AseguradosDependientes. Para insertar de manera manual los registros se recomienda un editor de archivos XML.<\/strong><\/p>\n\n\n\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\"\n     style=\"display:block; text-align:center;\"\n     data-ad-layout=\"in-article\"\n     data-ad-format=\"fluid\"\n     data-ad-client=\"ca-pub-2636008503986218\"\n     data-ad-slot=\"1902193434\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n\n<p>Create table Asegurados<br>(<br>AseguradosCodigo nchar(6),<br>AseguradosNombreCompleto nvarchar(200),<br><strong>AseguradosDependientes XML,<br><\/strong>AseguradosFechaNacimiento Date,<br>constraint AseguradosCodigoPK Primary key (AseguradosCodigo)<br>)<br>go<br><strong>&#8212; Insertar datos<\/strong><br>insert into Asegurados<br>(AseguradosCodigo, AseguradosNombreCompleto,<br>AseguradosDependientes, AseguradosFechaNacimiento)\u00a0 <br>values<br>(&#8216;852369&#8242;,&#8217;PEDRO CASTRO NIEVES&#8217;,'&lt;Dependientes><br>&lt;Dependiente><br>&lt;Codigo>7852&lt;\/Codigo><br>&lt;Nombre>Vilma&lt;\/Nombre><br>&lt;Paterno>Pereda&lt;\/Paterno><br>&lt;Materno>Plasencia&lt;\/Materno><br>&lt;Parentesco>Esposa&lt;\/Parentesco><br>&lt;\/Dependiente><br>&lt;Dependiente><br>&lt;Codigo>9615&lt;\/Codigo><br>&lt;Nombre>Jose&lt;\/Nombre><br>&lt;Paterno>Casto&lt;\/Paterno><br>&lt;Materno>Pereda&lt;\/Materno><br>&lt;Parentesco>Hijo&lt;\/Parentesco><br>&lt;\/Dependiente><br>&lt;Dependiente><br>&lt;Codigo>3578&lt;\/Codigo><br>&lt;Nombre>Paola&lt;\/Nombre><br>&lt;Paterno>Casto&lt;\/Paterno><br>&lt;Materno>Pereda&lt;\/Materno><br>&lt;Parentesco>Hija&lt;\/Parentesco><br>&lt;\/Dependiente><br>&lt;\/Dependientes>&#8217;,&#8217;15\/09\/1990&#8242;),<br>(&#8216;259716&#8242;,&#8217;CARMEN ZEGARRA LOPEZ&#8217;,'&lt;Dependientes><br>&lt;Dependiente><br>&lt;Codigo>7821&lt;\/Codigo><br>&lt;Nombre>Carlos&lt;\/Nombre><br>&lt;Paterno>Mendoza&lt;\/Paterno><br>&lt;Materno>Segura&lt;\/Materno><br>&lt;Parentesco>Esposo&lt;\/Parentesco><br>&lt;\/Dependiente><br>&lt;Dependiente><br>&lt;Codigo>2589&lt;\/Codigo><br>&lt;Nombre>Manuelita&lt;\/Nombre><br>&lt;Paterno>Mendoza&lt;\/Paterno><br>&lt;Materno>Zegarra&lt;\/Materno><br>&lt;Parentesco>Hija&lt;\/Parentesco><br>&lt;\/Dependiente><br>&lt;\/Dependientes>&#8217;,&#8217;04\/04\/1994&#8242;),<br>(&#8216;975281&#8242;,&#8217;ANTONIO MENDEZ VILLA&#8217;,'&lt;Dependientes><br>&lt;Dependiente><br>&lt;Codigo>8855&lt;\/Codigo><br>&lt;Nombre>Carlos&lt;\/Nombre><br>&lt;Paterno>Mendez&lt;\/Paterno><br>&lt;Materno>Polo&lt;\/Materno><br>&lt;Parentesco>Pap\u00e1&lt;\/Parentesco><br>&lt;\/Dependiente><br>&lt;\/Dependientes>&#8217;,&#8217;06\/06\/1966&#8242;)<br>go<\/p>\n\n\n\n<p><strong>Al listar los registros de la tabla se muestra el campo XML con las etiquetas escritas.<\/strong><br>select * from Asegurados<br>go<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_001-1-1024x170.png\" alt=\"\" class=\"wp-image-1245\" width=\"839\" height=\"139\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_001-1-1024x170.png 1024w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_001-1-300x50.png 300w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_001-1-768x127.png 768w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_001-1.png 1314w\" sizes=\"auto, (max-width: 839px) 100vw, 839px\" \/><\/figure><\/div>\n\n\n\n<p>Al pulsar clic en el campo XMl se muestra el detalle.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_002-1.png\" alt=\"\" class=\"wp-image-1246\" width=\"754\" height=\"703\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_002-1.png 618w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_002-1-300x280.png 300w\" sizes=\"auto, (max-width: 754px) 100vw, 754px\" \/><\/figure><\/div>\n\n\n\n<p><strong>Listados con campos XML, existen dos formas.<\/strong><\/p>\n\n\n\n<p>select * from Asegurados for xml Auto<br>go<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_004-1-1024x576.png\" alt=\"\" class=\"wp-image-1248\" width=\"875\" height=\"492\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_004-1-1024x576.png 1024w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_004-1-300x169.png 300w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_004-1-768x432.png 768w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_004-1.png 1234w\" sizes=\"auto, (max-width: 875px) 100vw, 875px\" \/><\/figure><\/div>\n\n\n\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\"\n     style=\"display:block; text-align:center;\"\n     data-ad-layout=\"in-article\"\n     data-ad-format=\"fluid\"\n     data-ad-client=\"ca-pub-2636008503986218\"\n     data-ad-slot=\"1902193434\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<p>Al pulsar clic en el XML que aparece se muestra lo siguiente:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Otra forma de listar los registros en el filas, incluyendo la palabra Raw.<\/strong><\/h2>\n\n\n\n<p>select * from Asegurados for xml Raw<br>go<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_005-1.png\" alt=\"\" class=\"wp-image-1249\" width=\"845\" height=\"691\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_005-1.png 848w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_005-1-300x246.png 300w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_CamposXML_005-1-768x629.png 768w\" sizes=\"auto, (max-width: 845px) 100vw, 845px\" \/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Campos XML en Tablas Los tipos de campo XML&nbsp;permiten guardar informaci\u00f3n estructurada que dependa del mismo registro. El uso de los tipos de datos XML es muy efectivo para elementos dependientes que no tengan muchos datos. Ejemplo: Asegurado y los Dependientes<\/p><p><a class=\"more-link btn\" href=\"https:\/\/manualsqlserver.com\/?p=145\">Seguir leyendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":1244,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[28,46,47,57,95],"class_list":["post-145","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-esquemastablas","tag-esquemas","tag-particion","tag-permisos","tag-tablas","tag-xml","nodate","item-wrap"],"_links":{"self":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/145","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=145"}],"version-history":[{"count":1,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/145\/revisions"}],"predecessor-version":[{"id":1250,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/145\/revisions\/1250"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/media\/1244"}],"wp:attachment":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}